home *** CD-ROM | disk | FTP | other *** search
open in:
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: ArcFS Archive
(archive/arcFS).
You can browse this item here: 8_02
Confidence | Program | Detection | Match Type | Support
|
---|
100%
| dexvert
| ArcFS Archive (archive/arcFS)
| magic
| Supported |
100%
| file
| RISC OS archive (ArcFS format)
| default
| |
99%
| file
| data
| default
| |
100%
| TrID
| Acorn ArcFS Archive
| default
| |
100%
| gt2
| Kopftext: 'Archive'
| default (weak)
| |
100%
| detectItEasy
| Archive: ArcFS
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 41 72 63 68 69 76 65 00 | 18 03 00 00 24 06 00 00 |Archive.|....$...|
|00000010| 28 00 00 00 64 00 00 00 | 00 00 00 00 00 00 00 00 |(...d...|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 82 43 72 6f 73 73 43 68 | 65 63 6b 00 ff ff ff ff |.CrossCh|eck.....|
|00000070| 45 dc fd ff 96 43 64 a3 | 33 00 00 00 ff ff ff ff |E....Cd.|3.......|
|00000080| b4 00 00 80 82 63 5f 53 | 61 6d 65 00 fd 00 fd fd |.....c_S|ame.....|
|00000090| 46 02 00 00 45 de fd ff | 24 73 d1 7b 03 00 cf 23 |F...E...|$s.{...#|
|000000a0| 46 02 00 00 24 00 00 00 | 82 45 72 72 6f 72 43 68 |F...$...|.ErrorCh|
|000000b0| 65 63 6b 00 83 03 00 00 | 45 de fd ff 31 da cf 7b |eck.....|E...1..{|
|000000c0| 03 00 61 7e 83 03 00 00 | 8e 02 00 00 82 52 65 61 |..a~....|.....Rea|
|000000d0| 64 4d 65 00 fd 00 fd fd | 7a 31 00 00 45 de fd ff |dMe.....|z1..E...|
|000000e0| b7 da 72 7c 03 00 1e 3c | 7a 31 00 00 35 06 00 00 |..r|...<|z1..5...|
|000000f0| 00 00 00 00 c3 00 04 00 | fd 00 fd fd fd fd ff ff |........|........|
|00000100| fd fd fd fd fd fd fd fd | fd fd 00 fd 00 fd d1 fd |........|........|
|00000110| ed cd 0c fb 82 50 44 2f | 50 73 69 6f 6e 00 00 00 |.....PD/|Psion...|
|00000120| ff ff ff ff 45 dc fd ff | 0f 44 64 a3 33 00 00 00 |....E...|.Dd.3...|
|00000130| ff ff ff ff 1c 02 00 80 | 82 41 74 74 65 6e 2f 73 |........|.Atten/s|
|00000140| 70 72 00 fd 1c 07 00 00 | 45 bc ff ff a8 f7 a7 81 |pr......|E.......|
|00000150| 03 00 76 51 1c 07 00 00 | d3 37 00 00 82 41 74 74 |..vQ....|.7...Att|
|00000160| 65 6e 2f 77 6b 31 00 fd | 7b 0a 00 00 45 b0 fd ff |en/wk1..|{...E...|
|00000170| 78 d9 a1 81 03 00 e1 9d | 7b 0a 00 00 13 3f 00 00 |x.......|{....?..|
|00000180| 82 41 74 74 65 6e 75 61 | 74 6f 72 00 67 04 00 00 |.Attenua|tor.g...|
|00000190| 45 de fd ff e8 d4 a1 81 | 03 00 41 80 67 04 00 00 |E.......|..A.g...|
|000001a0| b2 49 00 00 82 50 44 3e | 50 73 69 6f 6e 53 53 00 |.I...PD>|PsionSS.|
|000001b0| 10 20 00 00 45 de fd ff | ce 71 a7 81 03 00 1c 9f |. ..E...|.q......|
|000001c0| 10 20 00 00 3d 4e 00 00 | 82 50 44 3e 50 73 53 53 |. ..=N..|.PD>PsSS|
|000001d0| 00 fd fd fd 73 08 00 00 | 45 de fd ff d4 8a 21 6e |....s...|E.....!n|
|000001e0| 03 00 72 3c 73 08 00 00 | 71 6e 00 00 82 50 73 69 |..r<s...|qn...Psi|
|000001f0| 6f 6e 53 53 3e 50 44 00 | 4e 1d 00 00 45 de fd ff |onSS>PD.|N...E...|
|00000200| 50 e7 a7 81 03 00 96 b2 | 4e 1d 00 00 08 77 00 00 |P.......|N....w..|
|00000210| 82 50 73 53 53 3e 50 44 | 00 fd fd fd 7c 08 00 00 |.PsSS>PD|....|...|
|00000220| 45 de fd ff 8d 48 2a 6e | 03 00 fb 5b 7c 08 00 00 |E....H*n|...[|...|
|00000230| 7a 94 00 00 82 52 65 61 | 64 4d 65 00 fd fd fd fd |z....Rea|dMe.....|
|00000240| 31 19 00 00 45 de fd ff | 15 5b 1e 97 03 00 c4 a3 |1...E...|.[......|
|00000250| 31 19 00 00 1a 9d 00 00 | 00 fd fd fd fd fd fd fd |1.......|........|
|00000260| fd fd fd fd fd d3 00 fd | 00 fd 00 fd fd fd fd fd |........|........|
|00000270| fd fd fd fd fd fd fd fd | 19 ce de fd 82 53 74 61 |........|.....Sta|
|00000280| 6d 70 73 00 00 00 00 00 | ff ff ff ff 45 dc fd ff |mps.....|....E...|
|00000290| 54 45 64 a3 33 00 00 00 | ff ff ff ff f4 02 00 80 |TEd.3...|........|
|000002a0| 82 43 61 6c 63 53 74 61 | 6d 70 73 00 52 22 00 00 |.CalcSta|mps.R"..|
|000002b0| 45 df fb ff 49 19 34 95 | 03 00 e7 80 52 22 00 00 |E...I.4.|....R"..|
|000002c0| 6f b6 00 00 82 50 6f 73 | 74 53 74 61 6d 70 73 00 |o....Pos|tStamps.|
|000002d0| f7 01 00 00 45 fb ff ff | 75 4b 19 90 03 00 52 f4 |....E...|uK....R.|
|000002e0| f7 01 00 00 e5 d8 00 00 | 82 52 65 61 64 4d 65 00 |........|.ReadMe.|
|000002f0| 00 0d 00 00 1c 01 00 00 | 45 ff ff ff f4 ad fb 92 |........|E.......|
|00000300| 03 00 2d 55 1c 01 00 00 | 00 db 00 00 82 53 74 61 |..-U....|.....Sta|
|00000310| 6d 70 4e 6f 73 00 00 00 | a3 0a 00 00 45 de fd ff |mpNos...|....E...|
|00000320| 2d 18 26 8a 03 00 33 fa | a3 0a 00 00 40 dc 00 00 |-.&...3.|....@...|
|00000330| 00 ff ff ff 38 00 0e 07 | 00 0d 00 00 00 00 00 00 |....8...|........|
|00000340| 00 00 00 00 18 00 00 00 | f8 fe ff ff ee 00 00 00 |........|........|
|00000350| 40 cf de fd 00 00 00 00 | 00 00 00 00 00 00 00 00 |@.......|........|
|00000360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000370| 00 00 00 00 00 00 00 00 | 25 4f 50 25 56 53 34 2e |........|%OP%VS4.|
|00000380| 31 33 20 28 32 38 2d 41 | 70 72 2d 39 32 29 2c 20 |13 (28-A|pr-92), |
|00000390| 47 65 72 61 6c 64 20 4c | 20 46 69 74 74 6f 6e 2c |Gerald L| Fitton,|
|000003a0| 20 52 34 30 30 30 20 35 | 39 36 36 20 39 39 30 34 | R4000 5|966 9904|
|000003b0| 20 39 39 33 38 20 0a 25 | 4f 50 25 54 4e 4e 0a 25 | 9938 .%|OP%TNN.%|
|000003c0| 4f 50 25 57 52 4e 0a 25 | 4f 50 25 44 50 30 0a 25 |OP%WRN.%|OP%DP0.%|
|000003d0| 4f 50 25 49 52 4e 0a 25 | 4f 50 25 50 4c 30 0a 25 |OP%IRN.%|OP%PL0.%|
|000003e0| 4f 50 25 48 4d 30 0a 25 | 4f 50 25 46 4d 30 0a 25 |OP%HM0.%|OP%FM0.%|
|000003f0| 4f 50 25 42 4d 30 0a 25 | 4f 50 25 4c 4d 34 0a 25 |OP%BM0.%|OP%LM4.%|
|00000400| 4f 50 25 50 54 31 0a 25 | 4f 50 25 50 44 50 69 70 |OP%PT1.%|OP%PDPip|
|00000410| 65 4c 69 6e 65 0a 25 4f | 50 25 57 43 32 2c 31 32 |eLine.%O|P%WC2,12|
|00000420| 34 38 2c 34 34 2c 36 30 | 30 2c 30 2c 31 2c 30 2c |48,44,60|0,0,1,0,|
|00000430| 32 0a 25 4f 50 25 46 52 | 30 2c 32 0a 25 43 4f 3a |2.%OP%FR|0,2.%CO:|
|00000440| 41 2c 34 36 2c 37 32 25 | 43 6f 6d 6d 65 6e 74 73 |A,46,72%|Comments|
|00000450| 20 61 6e 64 20 43 6f 6d | 6d 61 6e 64 73 0a 0a 2d | and Com|mands..-|
|00000460| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000470| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000480| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000490| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000004a0| 2d 2d 2d 2d 2d 2d 2d 0a | 0a 46 75 6e 63 74 69 6f |-------.|.Functio|
|000004b0| 6e 20 22 73 61 6d 65 5f | 6e 75 6d 62 65 72 22 0a |n "same_|number".|
|000004c0| 0a 43 68 65 63 6b 73 20 | 77 68 65 74 68 65 72 20 |.Checks |whether |
|000004d0| 22 66 69 72 73 74 22 20 | 61 6e 64 20 22 73 65 63 |"first" |and "sec|
|000004e0| 6f 6e 64 22 20 61 72 65 | 20 27 6e 65 61 72 20 65 |ond" are| 'near e|
|000004f0| 6e 6f 75 67 68 27 20 74 | 68 65 20 73 61 6d 65 0a |nough' t|he same.|
|00000500| 0a 25 56 25 25 4c 25 66 | 75 6e 63 74 69 6f 6e 28 |.%V%%L%f|unction(|
|00000510| 22 73 61 6d 65 5f 6e 75 | 6d 62 65 72 22 2c 22 66 |"same_nu|mber","f|
|00000520| 69 72 73 74 3a 6e 75 6d | 62 65 72 22 2c 22 73 65 |irst:num|ber","se|
|00000530| 63 6f 6e 64 3a 6e 75 6d | 62 65 72 22 29 0a 0a 25 |cond:num|ber")..%|
|00000540| 56 25 25 4c 25 69 66 28 | 61 62 73 28 40 66 69 72 |V%%L%if(|abs(@fir|
|00000550| 73 74 2d 40 73 65 63 6f | 6e 64 29 2f 28 40 66 69 |st-@seco|nd)/(@fi|
|00000560| 72 73 74 2b 40 73 65 63 | 6f 6e 64 29 3c 28 31 65 |rst+@sec|ond)<(1e|
|00000570| 2d 31 36 29 2c 22 4f 4b | 22 2c 22 45 72 72 6f 72 |-16),"OK|","Error|
|00000580| 22 29 0a 0a 25 56 25 25 | 4c 25 72 65 73 75 6c 74 |")..%V%%|L%result|
|00000590| 28 41 31 31 29 0a 25 43 | 4f 3a 42 2c 36 2c 30 25 |(A11).%C|O:B,6,0%|
|000005a0| 56 61 6c 75 65 0a 0a 0a | 0a 0a 0a 0a 25 43 4f 3a |Value...|....%CO:|
|000005b0| 43 2c 32 30 2c 30 25 0a | 0a 0a 0a 0a 0a 0a 46 69 |C,20,0%.|......Fi|
|000005c0| 6c 65 44 61 74 61 82 45 | 72 72 6f 72 43 68 65 63 |leData.E|rrorChec|
|000005d0| 6b 00 83 03 00 00 45 de | fd ff 31 da cf 7b 03 00 |k.....E.|..1..{..|
|000005e0| 61 7e 25 4f 50 25 56 53 | 34 2e 31 33 20 28 32 38 |a~%OP%VS|4.13 (28|
|000005f0| 2d 41 70 72 2d 39 32 29 | 2c 20 47 65 72 61 6c 64 |-Apr-92)|, Gerald|
|00000600| 20 4c 20 46 69 74 74 6f | 6e 2c 20 52 34 30 30 30 | L Fitto|n, R4000|
|00000610| 20 35 39 36 36 20 39 39 | 30 34 20 39 39 33 38 20 | 5966 99|04 9938 |
|00000620| 0a 25 4f 50 46 69 6c 65 | 44 61 74 61 82 63 5f 53 |.%OPFile|Data.c_S|
|00000630| 61 6d 65 00 fd 00 fd fd | 46 02 00 00 45 de fd ff |ame.....|F...E...|
|00000640| 24 73 d1 7b 03 00 cf 23 | 25 4f 50 25 56 53 34 2e |$s.{...#|%OP%VS4.|
|00000650| 31 33 20 28 32 38 2d 41 | 70 72 2d 39 32 29 2c 20 |13 (28-A|pr-92), |
|00000660| 47 65 72 61 6c 64 20 4c | 20 46 69 74 74 6f 6e 2c |Gerald L| Fitton,|
|00000670| 20 52 34 30 30 30 20 35 | 39 36 36 20 39 39 30 34 | R4000 5|966 9904|
|00000680| 20 39 39 33 38 20 0a 25 | 4f 50 25 54 4e 4e 0a 25 | 9938 .%|OP%TNN.%|
|00000690| 4f 50 25 57 52 4e 0a 25 | 4f 50 25 44 50 30 0a 25 |OP%WRN.%|OP%DP0.%|
|000006a0| 4f 50 25 49 52 4e 0a 25 | 4f 50 25 50 4c 30 0a 25 |OP%IRN.%|OP%PL0.%|
|000006b0| 4f 50 25 48 4d 30 0a 25 | 4f 50 25 46 4d 30 0a 25 |OP%HM0.%|OP%FM0.%|
|000006c0| 4f 50 25 42 4d 30 0a 25 | 4f 50 25 4c 4d 34 0a 25 |OP%BM0.%|OP%LM4.%|
|000006d0| 4f 50 25 50 54 31 0a 25 | 4f 50 25 50 44 50 69 70 |OP%PT1.%|OP%PDPip|
|000006e0| 65 4c 69 6e 65 0a 25 4f | 50 25 57 43 32 2c 31 32 |eLine.%O|P%WC2,12|
|000006f0| 34 38 2c 34 34 2c 36 30 | 30 2c 30 2c 31 2c 30 2c |48,44,60|0,0,1,0,|
|00000700| 32 0a 25 4f 50 25 46 52 | 30 2c 32 0a 25 43 4f 3a |2.%OP%FR|0,2.%CO:|
|00000710| 41 2c 34 36 2c 37 32 25 | 43 6f 6d 6d 65 6e 74 73 |A,46,72%|Comments|
|00000720| 20 61 6e 64 20 43 6f 6d | 6d 61 6e 64 73 0a 0a 2d | and Com|mands..-|
|00000730| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000740| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000750| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000760| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000770| 2d 2d 2d 2d 2d 2d 2d 0a | 0a 46 75 6e 63 74 69 6f |-------.|.Functio|
|00000780| 6e 20 22 73 61 6d 65 5f | 6e 75 6d 62 65 72 22 0a |n "same_|number".|
|00000790| 0a 43 68 65 63 6b 73 20 | 77 68 65 74 68 65 72 20 |.Checks |whether |
|000007a0| 22 66 69 72 73 74 22 20 | 61 6e 64 20 22 73 65 63 |"first" |and "sec|
|000007b0| 6f 6e 64 22 20 61 72 65 | 20 27 6e 65 61 72 20 65 |ond" are| 'near e|
|000007c0| 6e 6f 75 67 68 27 20 74 | 68 65 20 73 61 6d 65 0a |nough' t|he same.|
|000007d0| 0a 25 56 25 25 4c 25 66 | 75 6e 63 74 69 6f 6e 28 |.%V%%L%f|unction(|
|000007e0| 22 73 61 6d 65 5f 6e 75 | 6d 62 65 72 22 2c 22 66 |"same_nu|mber","f|
|000007f0| 69 72 73 74 3a 6e 75 6d | 62 65 72 22 2c 22 73 65 |irst:num|ber","se|
|00000800| 63 6f 6e 64 3a 6e 75 6d | 62 65 72 22 29 0a 0a 25 |cond:num|ber")..%|
|00000810| 56 25 25 4c 25 69 66 28 | 61 62 73 28 40 66 69 72 |V%%L%if(|abs(@fir|
|00000820| 73 74 2d 40 73 65 63 6f | 6e 64 29 2f 28 40 66 69 |st-@seco|nd)/(@fi|
|00000830| 72 73 74 2b 40 73 65 63 | 6f 6e 64 29 3c 28 31 65 |rst+@sec|ond)<(1e|
|00000840| 2d 31 36 29 2c 22 4f 4b | 22 2c 22 45 72 72 6f 72 |-16),"OK|","Error|
|00000850| 22 29 0a 0a 25 56 25 25 | 4c 25 72 65 73 75 6c 74 |")..%V%%|L%result|
|00000860| 28 41 31 31 29 0a 25 43 | 4f 3a 42 2c 36 2c 30 25 |(A11).%C|O:B,6,0%|
|00000870| 56 61 6c 75 65 0a 0a 0a | 0a 0a 0a 0a 25 43 4f 3a |Value...|....%CO:|
|00000880| 43 2c 32 30 2c 30 25 0a | 0a 0a 0a 0a 0a 0a 46 69 |C,20,0%.|......Fi|
|00000890| 6c 65 44 61 74 61 82 45 | 72 72 6f 72 43 68 65 63 |leData.E|rrorChec|
|000008a0| 6b 00 83 03 00 00 45 de | fd ff 31 da cf 7b 03 00 |k.....E.|..1..{..|
|000008b0| 61 7e 25 4f 50 25 56 53 | 34 2e 31 33 20 28 32 38 |a~%OP%VS|4.13 (28|
|000008c0| 2d 41 70 72 2d 39 32 29 | 2c 20 47 65 72 61 6c 64 |-Apr-92)|, Gerald|
|000008d0| 20 4c 20 46 69 74 74 6f | 6e 2c 20 52 34 30 30 30 | L Fitto|n, R4000|
|000008e0| 20 35 39 36 36 20 39 39 | 30 34 20 39 39 33 38 20 | 5966 99|04 9938 |
|000008f0| 0a 25 4f 50 25 54 4e 4e | 0a 25 4f 50 25 57 52 4e |.%OP%TNN|.%OP%WRN|
|00000900| 0a 25 4f 50 25 44 50 32 | 0a 25 4f 50 25 49 52 4e |.%OP%DP2|.%OP%IRN|
|00000910| 0a 25 4f 50 25 50 4c 30 | 0a 25 4f 50 25 48 4d 30 |.%OP%PL0|.%OP%HM0|
|00000920| 0a 25 4f 50 25 46 4d 30 | 0a 25 4f 50 25 42 4d 30 |.%OP%FM0|.%OP%BM0|
|00000930| 0a 25 4f 50 25 4c 4d 34 | 0a 25 4f 50 25 50 54 31 |.%OP%LM4|.%OP%PT1|
|00000940| 0a 25 4f 50 25 50 44 50 | 69 70 65 4c 69 6e 65 0a |.%OP%PDP|ipeLine.|
|00000950| 25 4f 50 25 57 43 32 2c | 31 34 31 38 2c 36 39 32 |%OP%WC2,|1418,692|
|00000960| 2c 31 31 32 38 2c 37 2c | 39 2c 30 2c 30 0a 25 43 |,1128,7,|9,0,0.%C|
|00000970| 4f 3a 41 2c 33 2c 30 25 | 25 43 4f 3a 42 2c 38 2c |O:A,3,0%|%CO:B,8,|
|00000980| 30 25 0a 0a 25 52 25 41 | 70 72 0a 0a 25 56 25 25 |0%..%R%A|pr..%V%%|
|00000990| 52 25 30 0a 25 56 25 25 | 52 25 30 2e 32 0a 25 56 |R%0.%V%%|R%0.2.%V|
|000009a0| 25 25 52 25 30 2e 32 0a | 25 56 25 25 52 25 30 2e |%%R%0.2.|%V%%R%0.|
|000009b0| 32 0a 0a 25 56 25 25 52 | 25 73 75 6d 28 42 34 42 |2..%V%%R|%sum(B4B|
|000009c0| 39 29 0a 25 43 4f 3a 43 | 2c 31 30 2c 30 25 0a 0a |9).%CO:C|,10,0%..|
|000009d0| 25 52 25 4d 61 79 0a 0a | 25 56 25 25 52 25 30 2e |%R%May..|%V%%R%0.|
|000009e0| 30 31 0a 25 56 25 25 52 | 25 30 2e 30 31 0a 25 56 |01.%V%%R|%0.01.%V|
|000009f0| 25 25 52 25 30 2e 30 31 | 0a 25 56 25 25 52 25 30 |%%R%0.01|.%V%%R%0|
|00000a00| 2e 30 31 0a 0a 25 56 25 | 25 52 25 73 75 6d 28 43 |.01..%V%|%R%sum(C|
|00000a10| 34 43 39 29 0a 25 43 4f | 3a 44 2c 31 30 2c 30 25 |4C9).%CO|:D,10,0%|
|00000a20| 0a 0a 25 52 25 4a 75 6e | 0a 0a 25 56 25 25 52 25 |..%R%Jun|..%V%%R%|
|00000a30| 30 2e 30 31 0a 25 56 25 | 25 52 25 30 2e 30 31 0a |0.01.%V%|%R%0.01.|
|00000a40| 25 56 25 25 52 25 30 2e | 30 31 0a 25 56 25 25 52 |%V%%R%0.|01.%V%%R|
|00000a50| 25 30 2e 30 31 0a 0a 25 | 56 25 25 52 25 73 75 6d |%0.01..%|V%%R%sum|
|00000a60| 28 44 34 44 39 29 0a 25 | 43 4f 3a 45 2c 31 30 2c |(D4D9).%|CO:E,10,|
|00000a70| 30 25 0a 0a 25 52 25 4a | 75 6c 0a 0a 25 56 25 25 |0%..%R%J|ul..%V%%|
|00000a80| 52 25 30 2e 30 31 0a 25 | 56 25 25 52 25 30 2e 30 |R%0.01.%|V%%R%0.0|
|00000a90| 31 0a 25 56 25 25 52 25 | 30 2e 30 31 0a 25 56 25 |1.%V%%R%|0.01.%V%|
|00000aa0| 25 52 25 30 2e 30 31 0a | 0a 25 56 25 25 52 25 73 |%R%0.01.|.%V%%R%s|
|00000ab0| 75 6d 28 45 34 45 39 29 | 0a 25 43 4f 3a 46 2c 32 |um(E4E9)|.%CO:F,2|
|00000ac0| 2c 30 25 25 43 4f 3a 47 | 2c 38 2c 30 25 0a 0a 25 |,0%%CO:G|,8,0%..%|
|00000ad0| 52 25 54 6f 74 61 6c 0a | 0a 25 56 25 25 52 25 73 |R%Total.|.%V%%R%s|
|00000ae0| 75 6d 28 41 35 46 35 29 | 0a 25 56 25 25 52 25 73 |um(A5F5)|.%V%%R%s|
|00000af0| 75 6d 28 41 36 46 36 29 | 0a 25 56 25 25 52 25 73 |um(A6F6)|.%V%%R%s|
|00000b00| 75 6d 28 41 37 46 37 29 | 0a 25 56 25 25 52 25 73 |um(A7F7)|.%V%%R%s|
|00000b10| 75 6d 28 41 38 46 38 29 | 0a 0a 25 56 25 25 52 25 |um(A8F8)|..%V%%R%|
|00000b20| 73 75 6d 28 41 31 30 46 | 31 30 29 0a 25 43 4f 3a |sum(A10F|10).%CO:|
|00000b30| 48 2c 38 2c 30 25 0a 0a | 25 52 25 54 65 73 74 a0 |H,8,0%..|%R%Test.|
|00000b40| 31 0a 0a 0a 0a 0a 0a 0a | 25 56 25 25 52 25 69 66 |1.......|%V%%R%if|
|00000b50| 28 28 73 75 6d 28 47 34 | 47 39 29 2d 73 75 6d 28 |((sum(G4|G9)-sum(|
|00000b60| 41 31 30 46 31 30 29 29 | 3d 30 2c 22 4f 4b 22 2c |A10F10))|=0,"OK",|
|00000b70| 22 45 72 72 6f 72 22 29 | 0a 25 43 4f 3a 49 2c 38 |"Error")|.%CO:I,8|
|00000b80| 2c 30 25 0a 0a 25 52 25 | 54 65 73 74 a0 32 0a 0a |,0%..%R%|Test.2..|
|00000b90| 0a 0a 0a 0a 0a 25 56 25 | 25 52 25 69 66 28 61 62 |.....%V%|%R%if(ab|
|00000ba0| 73 28 73 75 6d 28 47 34 | 47 39 29 2d 73 75 6d 28 |s(sum(G4|G9)-sum(|
|00000bb0| 41 31 30 46 31 30 29 29 | 2f 28 73 75 6d 28 47 34 |A10F10))|/(sum(G4|
|00000bc0| 47 39 29 2b 73 75 6d 28 | 41 31 30 46 31 30 29 29 |G9)+sum(|A10F10))|
|00000bd0| 3c 28 31 65 2d 31 30 29 | 2c 22 4f 4b 22 2c 22 45 |<(1e-10)|,"OK","E|
|00000be0| 72 72 6f 72 22 29 0a 25 | 43 4f 3a 4a 2c 38 2c 30 |rror").%|CO:J,8,0|
|00000bf0| 25 0a 0a 25 52 25 54 65 | 73 74 a0 33 0a 0a 0a 0a |%..%R%Te|st.3....|
|00000c00| 0a 0a 0a 25 56 25 25 52 | 25 5b 63 5f 53 61 6d 65 |...%V%%R|%[c_Same|
|00000c10| 5d 73 61 6d 65 5f 6e 75 | 6d 62 65 72 28 73 75 6d |]same_nu|mber(sum|
|00000c20| 28 47 34 47 39 29 2c 73 | 75 6d 28 41 31 30 46 31 |(G4G9),s|um(A10F1|
|00000c30| 30 29 29 0a 0a 46 69 6c | 65 44 61 74 61 82 52 65 |0))..Fil|eData.Re|
|00000c40| 61 64 4d 65 00 fd 00 fd | fd 7a 31 00 00 45 de fd |adMe....|.z1..E..|
|00000c50| ff b7 da 72 7c 03 00 1e | 3c 25 4f 50 25 56 53 34 |...r|...|<%OP%VS4|
|00000c60| 2e 31 33 20 28 32 38 2d | 41 70 72 2d 39 32 29 2c |.13 (28-|Apr-92),|
|00000c70| 20 47 65 72 61 6c 64 20 | 4c 20 46 69 74 74 6f 6e | Gerald |L Fitton|
|00000c80| 2c 20 52 34 30 30 30 20 | 35 39 36 36 20 39 39 30 |, R4000 |5966 990|
|00000c90| 34 20 39 39 33 38 20 0a | 25 4f 50 25 44 50 30 0a |4 9938 .|%OP%DP0.|
|00000ca0| 25 4f 50 25 49 52 59 0a | 25 4f 50 25 50 4c 30 0a |%OP%IRY.|%OP%PL0.|
|00000cb0| 25 4f 50 25 48 4d 30 0a | 25 4f 50 25 46 4d 30 0a |%OP%HM0.|%OP%FM0.|
|00000cc0| 25 4f 50 25 42 4d 30 0a | 25 4f 50 25 4c 4d 34 0a |%OP%BM0.|%OP%LM4.|
|00000cd0| 25 4f 50 25 50 54 31 0a | 25 4f 50 25 50 44 50 69 |%OP%PT1.|%OP%PDPi|
|00000ce0| 70 65 4c 69 6e 65 0a 25 | 4f 50 25 57 43 32 2c 31 |peLine.%|OP%WC2,1|
|00000cf0| 32 33 38 2c 34 34 2c 31 | 37 34 38 2c 30 2c 30 2c |238,44,1|748,0,0,|
|00000d00| 30 2c 30 0a 25 43 4f 3a | 41 2c 37 32 2c 37 32 25 |0,0.%CO:|A,72,72%|
|00000d10| 0a 25 43 25 43 72 6f 73 | 73 20 43 68 65 63 6b 73 |.%C%Cros|s Checks|
|00000d20| 0a 25 43 25 62 79 20 47 | 65 72 61 6c 64 20 4c 20 |.%C%by G|erald L |
|00000d30| 46 69 74 74 6f 6e 0a 4b | 65 79 77 6f 72 64 73 3a |Fitton.K|eywords:|
|00000d40| 0a 43 68 65 63 6b 20 45 | 72 72 6f 72 20 46 69 74 |.Check E|rror Fit|
|00000d50| 74 6f 6e 0a 0a 0a 49 6e | 74 72 6f 64 75 63 74 69 |ton...In|troducti|
|00000d60| 6f 6e 0a 0a 41 6c 74 68 | 6f 75 67 68 20 6d 79 20 |on..Alth|ough my |
|00000d70| 27 64 61 79 20 6a 6f 62 | 27 20 69 73 20 74 65 61 |'day job|' is tea|
|00000d80| 63 68 69 6e 67 20 61 6c | 6d 6f 73 74 20 61 6e 79 |ching al|most any|
|00000d90| 74 68 69 6e 67 20 72 65 | 6c 61 74 65 64 20 74 6f |thing re|lated to|
|00000da0| 20 0a 4d 61 74 68 65 6d | 61 74 69 63 73 20 28 66 | .Mathem|atics (f|
|00000db0| 72 6f 6d 20 53 74 61 74 | 69 73 74 69 63 73 2c 20 |rom Stat|istics, |
|00000dc0| 46 6f 75 72 69 65 72 20 | 41 6e 61 6c 79 73 69 73 |Fourier |Analysis|
|00000dd0| 2c 20 53 74 72 65 73 73 | 20 41 6e 61 6c 79 73 69 |, Stress| Analysi|
|00000de0| 73 20 6f 66 20 0a 53 74 | 72 75 63 74 75 72 65 73 |s of .St|ructures|
|00000df0| 20 61 6e 64 20 65 76 65 | 6e 20 45 63 6f 6e 6f 6d | and eve|n Econom|
|00000e00| 69 63 73 29 20 61 74 20 | 74 68 65 20 6c 6f 63 61 |ics) at |the loca|
|00000e10| 6c 20 43 6f 6c 6c 65 67 | 65 20 6f 66 20 46 75 72 |l Colleg|e of Fur|
|00000e20| 74 68 65 72 20 0a 45 64 | 75 63 61 74 69 6f 6e 20 |ther .Ed|ucation |
|00000e30| 6d 79 20 6b 6e 6f 77 6c | 65 64 67 65 20 6f 66 20 |my knowl|edge of |
|00000e40| 77 68 61 74 20 67 6f 65 | 73 20 6f 6e 20 28 4d 61 |what goe|s on (Ma|
|00000e50| 74 68 65 6d 61 74 69 63 | 61 6c 6c 79 20 73 70 65 |thematic|ally spe|
|00000e60| 61 6b 69 6e 67 29 20 69 | 6e 20 0a 50 72 69 6d 61 |aking) i|n .Prima|
|00000e70| 72 79 20 61 6e 64 20 53 | 65 63 6f 6e 64 61 72 79 |ry and S|econdary|
|00000e80| 20 53 63 68 6f 6f 6c 73 | 20 69 73 20 6c 69 6d 69 | Schools| is limi|
|00000e90| 74 65 64 20 74 6f 20 74 | 61 6c 65 73 20 74 6f 6c |ted to t|ales tol|
|00000ea0| 64 20 6d 65 20 62 79 20 | 6d 79 20 31 36 20 79 65 |d me by |my 16 ye|
|00000eb0| 61 72 20 0a 6f 6c 64 20 | 73 74 75 64 65 6e 74 73 |ar .old |students|
|00000ec0| 2e 20 20 50 65 72 68 61 | 70 73 20 61 20 50 69 70 |. Perha|ps a Pip|
|00000ed0| 65 4c 69 6e 65 20 61 72 | 74 69 63 6c 65 20 69 73 |eLine ar|ticle is|
|00000ee0| 20 6e 6f 74 20 74 68 65 | 20 70 6c 61 63 65 20 74 | not the| place t|
|00000ef0| 6f 20 65 6e 74 65 72 20 | 0a 69 6e 74 6f 20 61 20 |o enter |.into a |
|00000f00| 64 69 73 63 75 73 73 69 | 6f 6e 20 61 73 20 74 6f |discussi|on as to|
|00000f10| 20 77 68 65 74 68 65 72 | 20 74 68 65 20 73 74 61 | whether| the sta|
|00000f20| 6e 64 61 72 64 73 20 6f | 66 20 70 72 65 20 46 75 |ndards o|f pre Fu|
|00000f30| 72 74 68 65 72 20 45 64 | 75 63 61 74 69 6f 6e 20 |rther Ed|ucation |
|00000f40| 0a 4e 75 6d 65 72 61 63 | 79 20 68 61 76 65 20 72 |.Numerac|y have r|
|00000f50| 69 73 65 6e 20 6f 72 20 | 66 61 6c 6c 65 6e 3b 20 |isen or |fallen; |
|00000f60| 49 20 64 6f 6e 27 74 20 | 69 6e 74 65 6e 64 20 74 |I don't |intend t|
|00000f70| 6f 20 73 61 79 20 61 6e | 79 74 68 69 6e 67 20 6f |o say an|ything o|
|00000f80| 6e 20 74 68 61 74 20 0a | 73 75 62 6a 65 63 74 20 |n that .|subject |
|00000f90| 61 74 20 70 72 65 73 65 | 6e 74 20 28 62 75 74 20 |at prese|nt (but |
|00000fa0| 49 27 6d 20 6d 6f 72 65 | 20 74 68 61 6e 20 77 69 |I'm more| than wi|
|00000fb0| 6c 6c 69 6e 67 20 74 6f | 20 6c 69 73 74 65 6e 20 |lling to| listen |
|00000fc0| 74 6f 20 79 6f 75 72 20 | 0a 63 6f 6d 6d 65 6e 74 |to your |.comment|
|00000fd0| 73 29 2e 20 20 48 6f 77 | 65 76 65 72 2c 20 49 20 |s). How|ever, I |
|00000fe0| 64 6f 20 66 65 65 6c 20 | 61 62 6c 65 20 74 6f 20 |do feel |able to |
|00000ff0| 73 61 79 2c 20 77 69 74 | 68 6f 75 74 20 66 65 61 |say, wit|hout fea|
|00001000| 72 20 6f 66 20 62 65 69 | 6e 67 20 0a 63 6f 72 72 |r of bei|ng .corr|
|00001010| 65 63 74 65 64 2c 20 74 | 68 61 74 20 74 68 61 74 |ected, t|hat that|
|00001020| 20 74 68 65 20 4d 61 74 | 68 65 6d 61 74 69 63 73 | the Mat|hematics|
|00001030| 20 74 61 75 67 68 74 20 | 61 74 20 50 72 69 6d 61 | taught |at Prima|
|00001040| 72 79 20 61 6e 64 20 53 | 65 63 6f 6e 64 61 72 79 |ry and S|econdary|
|00001050| 20 0a 53 63 68 6f 6f 6c | 73 20 6e 6f 77 61 64 61 | .School|s nowada|
|00001060| 79 73 20 69 73 20 64 65 | 66 69 6e 69 74 65 6c 79 |ys is de|finitely|
|00001070| 20 64 69 66 66 65 72 65 | 6e 74 20 66 72 6f 6d 20 | differe|nt from |
|00001080| 74 68 61 74 20 77 68 69 | 63 68 20 49 20 77 61 73 |that whi|ch I was|
|00001090| 20 74 61 75 67 68 74 2e | 0a 0a 48 65 6e 63 65 2c | taught.|..Hence,|
|000010a0| 20 69 74 20 69 73 20 77 | 69 74 68 20 73 6f 6d 65 | it is w|ith some|
|000010b0| 20 74 72 65 70 69 64 61 | 74 69 6f 6e 20 61 6e 64 | trepida|tion and|
|000010c0| 20 69 6e 20 61 6e 74 69 | 63 69 70 61 74 69 6f 6e | in anti|cipation|
|000010d0| 20 6f 66 20 62 65 69 6e | 67 20 64 65 6c 75 67 65 | of bein|g deluge|
|000010e0| 64 20 0a 62 79 20 22 54 | 68 69 6e 67 73 20 61 69 |d .by "T|hings ai|
|000010f0| 6e 27 74 20 77 68 61 74 | 20 74 68 65 79 20 75 73 |n't what| they us|
|00001100| 65 64 20 74 6f 20 62 65 | 22 20 6d 61 69 6c 20 28 |ed to be|" mail (|
|00001110| 62 75 74 20 49 20 77 6f | 6e 27 74 20 6d 69 6e 64 |but I wo|n't mind|
|00001120| 20 2d 20 68 6f 6e 65 73 | 74 29 20 0a 74 68 61 74 | - hones|t) .that|
|00001130| 20 49 20 6d 65 6e 74 69 | 6f 6e 20 74 68 65 20 69 | I menti|on the i|
|00001140| 6e 73 74 72 75 63 74 69 | 6f 6e 20 49 20 72 65 63 |nstructi|on I rec|
|00001150| 65 69 76 65 64 20 61 74 | 20 4d 61 72 6b 65 74 20 |eived at| Market |
|00001160| 44 72 61 79 74 6f 6e 20 | 28 53 61 6c 6f 70 29 20 |Drayton |(Salop) |
|00001170| 0a 4a 75 6e 69 6f 72 20 | 53 63 68 6f 6f 6c 20 77 |.Junior |School w|
|00001180| 68 65 6e 20 49 20 77 61 | 73 20 65 69 67 68 74 20 |hen I wa|s eight |
|00001190| 79 65 61 72 73 20 6f 6c | 64 2e 20 20 49 20 6d 75 |years ol|d. I mu|
|000011a0| 73 74 20 72 65 6d 69 6e | 64 20 74 68 6f 73 65 20 |st remin|d those |
|000011b0| 6f 66 20 79 6f 75 20 0a | 77 68 6f 20 6e 65 76 65 |of you .|who neve|
|000011c0| 72 20 6b 6e 65 77 20 74 | 68 65 20 6e 61 74 75 72 |r knew t|he natur|
|000011d0| 65 20 6f 66 20 74 68 65 | 20 45 64 75 63 61 74 69 |e of the| Educati|
|000011e0| 6f 6e 20 73 79 73 74 65 | 6d 20 62 65 66 6f 72 65 |on syste|m before|
|000011f0| 20 74 68 65 20 31 39 34 | 34 20 0a 45 64 75 63 61 | the 194|4 .Educa|
|00001200| 74 69 6f 6e 20 41 63 74 | 20 74 68 61 74 20 74 68 |tion Act| that th|
|00001210| 65 72 65 20 77 61 73 20 | 6e 6f 20 31 31 2b 20 62 |ere was |no 11+ b|
|00001220| 75 74 20 74 68 65 72 65 | 20 77 61 73 20 61 6e 20 |ut there| was an |
|00001230| 45 78 61 6d 69 6e 61 74 | 69 6f 6e 20 63 61 6c 6c |Examinat|ion call|
|00001240| 65 64 20 0a 74 68 65 20 | 22 53 63 68 6f 6c 61 72 |ed .the |"Scholar|
|00001250| 73 68 69 70 22 2e 20 20 | 54 68 6f 73 65 20 77 68 |ship". |Those wh|
|00001260| 6f 20 70 61 73 73 65 64 | 20 74 68 65 20 22 53 63 |o passed| the "Sc|
|00001270| 68 6f 6c 61 72 73 68 69 | 70 22 20 77 65 72 65 20 |holarshi|p" were |
|00001280| 65 6e 74 69 74 6c 65 64 | 20 74 6f 20 0a 61 20 22 |entitled| to .a "|
|00001290| 53 70 65 63 69 61 6c 20 | 50 6c 61 63 65 22 20 61 |Special |Place" a|
|000012a0| 74 20 74 68 65 20 6c 6f | 63 61 6c 20 47 72 61 6d |t the lo|cal Gram|
|000012b0| 6d 61 72 20 53 63 68 6f | 6f 6c 2e 20 20 54 68 65 |mar Scho|ol. The|
|000012c0| 20 47 72 61 6d 6d 61 72 | 20 53 63 68 6f 6f 6c 20 | Grammar| School |
|000012d0| 77 61 73 20 0a 61 20 70 | 72 69 76 61 74 65 20 62 |was .a p|rivate b|
|000012e0| 6f 64 79 20 61 6e 64 20 | 70 75 70 69 6c 73 20 70 |ody and |pupils p|
|000012f0| 61 69 64 20 66 65 65 73 | 20 75 6e 6c 65 73 73 20 |aid fees| unless |
|00001300| 74 68 65 79 20 68 61 64 | 20 61 20 22 53 70 65 63 |they had| a "Spec|
|00001310| 69 61 6c 20 50 6c 61 63 | 65 22 20 0a 28 69 6e 20 |ial Plac|e" .(in |
|00001320| 77 68 69 63 68 20 63 61 | 73 65 20 74 68 65 20 73 |which ca|se the s|
|00001330| 63 68 6f 6f 6c 20 66 65 | 65 73 20 77 65 72 65 20 |chool fe|es were |
|00001340| 6d 65 61 6e 73 20 74 65 | 73 74 65 64 20 61 6e 64 |means te|sted and|
|00001350| 20 70 61 69 64 2c 20 61 | 74 20 6c 65 61 73 74 20 | paid, a|t least |
|00001360| 69 6e 20 0a 70 61 72 74 | 2c 20 62 79 20 74 68 65 |in .part|, by the|
|00001370| 20 4c 6f 63 61 6c 20 45 | 64 75 63 61 74 69 6f 6e | Local E|ducation|
|00001380| 20 41 75 74 68 6f 72 69 | 74 79 29 2e 20 20 57 65 | Authori|ty). We|
|00001390| 20 77 65 72 65 20 70 6f | 6f 72 20 73 6f 20 74 68 | were po|or so th|
|000013a0| 61 74 20 74 68 65 20 6f | 6e 6c 79 20 0a 77 61 79 |at the o|nly .way|
|000013b0| 20 49 20 63 6f 75 6c 64 | 20 67 65 74 20 74 6f 20 | I could| get to |
|000013c0| 74 68 65 20 47 72 61 6d | 6d 61 72 20 53 63 68 6f |the Gram|mar Scho|
|000013d0| 6f 6c 20 77 6f 75 6c 64 | 20 62 65 20 62 79 20 70 |ol would| be by p|
|000013e0| 61 73 73 69 6e 67 20 74 | 68 65 20 0a 22 53 63 68 |assing t|he ."Sch|
|000013f0| 6f 6c 61 72 73 68 69 70 | 22 20 61 6e 64 20 73 6f |olarship|" and so|
|00001400| 20 67 61 69 6e 69 6e 67 | 20 61 20 22 53 70 65 63 | gaining| a "Spec|
|00001410| 69 61 6c 20 50 6c 61 63 | 65 22 2e 20 20 49 6e 20 |ial Plac|e". In |
|00001420| 74 68 6f 73 65 20 64 61 | 79 73 20 67 6f 69 6e 67 |those da|ys going|
|00001430| 20 74 6f 20 0a 74 68 65 | 20 47 72 61 6d 6d 61 72 | to .the| Grammar|
|00001440| 20 53 63 68 6f 6f 6c 20 | 77 61 73 20 63 6f 6e 73 | School |was cons|
|00001450| 69 64 65 72 65 64 20 74 | 6f 20 62 65 20 61 20 27 |idered t|o be a '|
|00001460| 67 6f 6f 64 20 74 68 69 | 6e 67 27 20 66 6f 72 20 |good thi|ng' for |
|00001470| 6d 69 64 64 6c 65 20 6f | 72 20 0a 77 6f 72 6b 69 |middle o|r .worki|
|00001480| 6e 67 20 63 6c 61 73 73 | 20 63 68 69 6c 64 72 65 |ng class| childre|
|00001490| 6e 20 28 73 75 63 68 20 | 61 73 20 6d 65 29 2e 20 |n (such |as me). |
|000014a0| 20 49 74 20 77 61 73 20 | 73 6f 6d 65 74 68 69 6e | It was |somethin|
|000014b0| 67 20 49 20 28 61 6e 64 | 20 6d 61 6e 79 20 0a 6f |g I (and| many .o|
|000014c0| 74 68 65 72 73 29 20 62 | 65 6c 69 65 76 65 64 20 |thers) b|elieved |
|000014d0| 77 65 20 68 61 64 20 74 | 6f 20 74 6f 20 77 6f 72 |we had t|o to wor|
|000014e0| 6b 20 74 6f 77 61 72 64 | 20 77 68 69 6c 73 74 20 |k toward| whilst |
|000014f0| 61 74 20 74 68 65 20 4a | 75 6e 69 6f 72 20 53 63 |at the J|unior Sc|
|00001500| 68 6f 6f 6c 2e 20 20 0a | 54 65 61 63 68 65 72 73 |hool. .|Teachers|
|00001510| 20 61 74 20 74 68 65 20 | 4a 75 6e 69 6f 72 20 53 | at the |Junior S|
|00001520| 63 68 6f 6f 6c 20 77 65 | 72 65 20 70 6c 65 61 73 |chool we|re pleas|
|00001530| 65 64 20 66 6f 72 20 61 | 6e 64 20 70 72 6f 75 64 |ed for a|nd proud|
|00001540| 20 6f 66 20 70 75 70 69 | 6c 73 20 77 68 6f 20 0a | of pupi|ls who .|
|00001550| 70 61 73 73 65 64 20 74 | 68 65 20 22 53 63 68 6f |passed t|he "Scho|
|00001560| 6c 61 72 73 68 69 70 22 | 2e 0a 0a 41 74 20 74 68 |larship"|...At th|
|00001570| 65 20 61 67 65 20 6f 66 | 20 65 69 67 68 74 20 6d |e age of| eight m|
|00001580| 79 20 65 64 75 63 61 74 | 69 6f 6e 20 77 61 73 20 |y educat|ion was |
|00001590| 28 61 6c 6d 6f 73 74 29 | 20 65 78 63 6c 75 73 69 |(almost)| exclusi|
|000015a0| 76 65 6c 79 20 45 6e 67 | 6c 69 73 68 20 61 6e 64 |vely Eng|lish and|
|000015b0| 20 0a 41 72 69 74 68 6d | 65 74 69 63 20 2d 20 69 | .Arithm|etic - i|
|000015c0| 6e 20 70 72 65 70 61 72 | 61 74 69 6f 6e 20 66 6f |n prepar|ation fo|
|000015d0| 72 20 74 68 65 20 22 53 | 63 68 6f 6c 61 72 73 68 |r the "S|cholarsh|
|000015e0| 69 70 22 20 77 68 69 63 | 68 20 77 65 20 77 6f 75 |ip" whic|h we wou|
|000015f0| 6c 64 20 74 61 6b 65 20 | 0a 61 74 20 74 68 65 20 |ld take |.at the |
|00001600| 61 67 65 20 6f 66 20 39 | 2c 20 31 30 20 6f 72 20 |age of 9|, 10 or |
|00001610| 31 31 20 28 61 63 63 6f | 72 64 69 6e 67 20 74 6f |11 (acco|rding to|
|00001620| 20 61 62 69 6c 69 74 79 | 29 2e 20 20 49 6e 20 45 | ability|). In E|
|00001630| 6e 67 6c 69 73 68 20 77 | 65 20 77 65 72 65 20 0a |nglish w|e were .|
|00001640| 74 61 75 67 68 74 20 47 | 72 61 6d 6d 61 72 20 61 |taught G|rammar a|
|00001650| 6e 64 20 43 6f 6d 70 72 | 65 68 65 6e 73 69 6f 6e |nd Compr|ehension|
|00001660| 20 61 73 20 77 65 6c 6c | 20 61 73 20 50 61 72 74 | as well| as Part|
|00001670| 73 20 6f 66 20 53 70 65 | 65 63 68 21 20 20 49 6e |s of Spe|ech! In|
|00001680| 20 0a 41 72 69 74 68 6d | 65 74 69 63 20 77 65 20 | .Arithm|etic we |
|00001690| 77 65 72 65 20 74 61 75 | 67 68 74 20 66 72 61 63 |were tau|ght frac|
|000016a0| 74 69 6f 6e 73 2c 20 72 | 61 74 69 6f 73 20 61 6e |tions, r|atios an|
|000016b0| 64 20 70 72 6f 70 6f 72 | 74 69 6f 6e 20 61 6e 64 |d propor|tion and|
|000016c0| 20 2d 20 77 61 69 74 20 | 0a 66 6f 72 20 69 74 20 | - wait |.for it |
|000016d0| 2d 20 74 68 65 20 73 75 | 62 6a 65 63 74 20 6f 66 |- the su|bject of|
|000016e0| 20 74 68 69 73 20 61 72 | 74 69 63 6c 65 20 2d 20 | this ar|ticle - |
|000016f0| 22 43 72 6f 73 73 20 43 | 68 65 63 6b 20 41 72 69 |"Cross C|heck Ari|
|00001700| 74 68 6d 65 74 69 63 22 | 2e 0a 0a 0a 45 72 72 6f |thmetic"|....Erro|
|00001710| 72 20 43 68 65 63 6b 73 | 0a 0a 44 75 72 69 6e 67 |r Checks|..During|
|00001720| 20 74 68 65 20 6c 61 73 | 74 20 73 69 78 20 6d 6f | the las|t six mo|
|00001730| 6e 74 68 73 20 49 20 68 | 61 76 65 20 72 65 63 65 |nths I h|ave rece|
|00001740| 69 76 65 64 20 61 20 77 | 65 61 6c 74 68 20 28 3f |ived a w|ealth (?|
|00001750| 29 20 6f 66 20 6d 61 69 | 6c 20 61 73 6b 69 6e 67 |) of mai|l asking|
|00001760| 20 0a 61 62 6f 75 74 20 | 22 43 72 6f 73 73 20 43 | .about |"Cross C|
|00001770| 68 65 63 6b 73 22 2e 20 | 20 54 68 69 73 20 74 6f |hecks". | This to|
|00001780| 70 69 63 20 68 61 73 20 | 63 6f 6d 65 20 74 6f 20 |pic has |come to |
|00001790| 74 68 65 20 66 6f 72 65 | 20 69 6e 20 72 65 63 65 |the fore| in rece|
|000017a0| 6e 74 0a 63 6f 72 72 65 | 73 70 6f 6e 64 65 6e 63 |nt.corre|spondenc|
|000017b0| 65 20 70 72 69 6d 61 72 | 69 6c 79 20 62 65 63 61 |e primar|ily beca|
|000017c0| 75 73 65 20 74 68 65 20 | 73 70 72 65 61 64 73 68 |use the |spreadsh|
|000017d0| 65 65 74 20 70 61 72 74 | 20 6f 66 20 56 65 72 73 |eet part| of Vers|
|000017e0| 69 6f 6e a0 31 2e 30 37 | 20 0a 6f 66 20 46 69 72 |ion.1.07| .of Fir|
|000017f0| 65 77 6f 72 6b 7a 20 73 | 6f 6d 65 74 69 6d 65 73 |eworkz s|ometimes|
|00001800| 20 64 6f 65 73 20 69 74 | 73 20 61 72 69 74 68 6d | does it|s arithm|
|00001810| 65 74 69 63 20 69 6e 63 | 6f 72 72 65 63 74 6c 79 |etic inc|orrectly|
|00001820| 20 28 6f 72 20 6e 6f 74 | 20 61 74 20 61 6c 6c 29 | (or not| at all)|
|00001830| 2e 20 20 0a 54 68 69 73 | 20 77 6f 75 6c 64 20 6e |. .This| would n|
|00001840| 6f 74 20 62 65 20 73 6f | 20 62 61 64 20 28 61 6e |ot be so| bad (an|
|00001850| 64 20 74 68 65 72 65 20 | 61 72 65 20 27 77 6f 72 |d there |are 'wor|
|00001860| 6b 20 61 72 6f 75 6e 64 | 73 27 29 20 65 78 63 65 |k around|s') exce|
|00001870| 70 74 20 66 6f 72 20 74 | 68 65 20 0a 66 61 63 74 |pt for t|he .fact|
|00001880| 20 74 68 61 74 20 69 74 | 20 64 6f 65 73 20 73 6f | that it| does so|
|00001890| 20 77 69 74 68 6f 75 74 | 20 67 65 6e 65 72 61 74 | without| generat|
|000018a0| 69 6e 67 20 61 6e 79 20 | 65 72 72 6f 72 20 6d 65 |ing any |error me|
|000018b0| 73 73 61 67 65 2e 20 20 | 4f 66 20 63 6f 75 72 73 |ssage. |Of cours|
|000018c0| 65 2c 20 0a 74 68 69 73 | 20 69 73 20 70 6f 74 65 |e, .this| is pote|
|000018d0| 6e 74 69 61 6c 6c 79 20 | 64 69 73 61 73 74 72 6f |ntially |disastro|
|000018e0| 75 73 20 66 6f 72 20 74 | 68 6f 73 65 20 75 73 69 |us for t|hose usi|
|000018f0| 6e 67 20 46 69 72 65 77 | 6f 72 6b 7a 20 66 6f 72 |ng Firew|orkz for|
|00001900| 20 74 68 65 69 72 20 0a | 61 63 63 6f 75 6e 74 73 | their .|accounts|
|00001910| 20 61 6e 64 20 49 20 63 | 61 6e 20 75 6e 64 65 72 | and I c|an under|
|00001920| 73 74 61 6e 64 20 77 68 | 79 20 74 68 6f 73 65 20 |stand wh|y those |
|00001930| 77 68 6f 20 65 78 70 65 | 72 69 65 6e 63 65 20 74 |who expe|rience t|
|00001940| 68 69 73 20 70 68 65 6e | 6f 6d 65 6e 6f 6e 0a 77 |his phen|omenon.w|
|00001950| 72 69 74 65 20 74 6f 20 | 6d 65 20 75 73 69 6e 67 |rite to |me using|
|00001960| 20 65 6d 6f 74 69 76 65 | 20 70 68 72 61 73 65 6f | emotive| phraseo|
|00001970| 6c 6f 67 79 20 72 61 74 | 68 65 72 20 74 68 61 6e |logy rat|her than|
|00001980| 20 6f 62 6a 65 63 74 69 | 76 65 20 63 6f 6d 6d 65 | objecti|ve comme|
|00001990| 6e 74 21 0a 0a 47 65 6e | 65 72 61 6c 6c 79 2c 20 |nt!..Gen|erally, |
|000019a0| 69 66 20 74 68 65 20 46 | 69 72 65 77 6f 72 6b 7a |if the F|ireworkz|
|000019b0| 20 73 70 72 65 61 64 73 | 68 65 65 74 20 69 73 20 | spreads|heet is |
|000019c0| 73 6d 61 6c 6c 20 74 68 | 65 6e 20 74 68 65 20 72 |small th|en the r|
|000019d0| 69 73 6b 20 6f 66 20 61 | 6e 20 0a 65 72 72 6f 72 |isk of a|n .error|
|000019e0| 20 69 73 20 73 6d 61 6c | 6c 20 61 6e 64 20 77 68 | is smal|l and wh|
|000019f0| 65 6e 20 6f 6e 65 20 6f | 63 63 75 72 73 20 69 74 |en one o|ccurs it|
|00001a00| 20 69 73 20 66 61 69 72 | 6c 79 20 6f 62 76 69 6f | is fair|ly obvio|
|00001a10| 75 73 3b 20 69 66 20 74 | 68 65 20 0a 73 70 72 65 |us; if t|he .spre|
|00001a20| 61 64 73 68 65 65 74 20 | 28 6f 72 20 73 65 74 20 |adsheet |(or set |
|00001a30| 6f 66 20 6c 69 6e 6b 65 | 64 20 64 6f 63 75 6d 65 |of linke|d docume|
|00001a40| 6e 74 73 29 20 69 73 20 | 6c 61 72 67 65 20 74 68 |nts) is |large th|
|00001a50| 65 6e 20 73 75 63 68 20 | 61 6e 20 0a 75 6e 72 65 |en such |an .unre|
|00001a60| 70 6f 72 74 65 64 20 65 | 72 72 6f 72 20 69 73 20 |ported e|rror is |
|00001a70| 6d 6f 72 65 20 6c 69 6b | 65 6c 79 20 61 6e 64 20 |more lik|ely and |
|00001a80| 6d 75 63 68 20 68 61 72 | 64 65 72 20 74 6f 20 73 |much har|der to s|
|00001a90| 70 6f 74 2e 0a 0a 49 20 | 68 61 76 65 20 68 61 64 |pot...I |have had|
|00001aa0| 20 6f 63 63 61 73 69 6f | 6e 20 74 6f 20 6e 6f 74 | occasio|n to not|
|00001ab0| 65 20 74 68 61 74 20 50 | 69 70 65 44 72 65 61 6d |e that P|ipeDream|
|00001ac0| 20 73 6f 6d 65 74 69 6d | 65 73 20 66 61 69 6c 73 | sometim|es fails|
|00001ad0| 20 74 6f 20 69 6e 63 6c | 75 64 65 20 0a 74 68 65 | to incl|ude .the|
|00001ae0| 20 6d 6f 73 74 20 72 65 | 63 65 6e 74 20 6e 75 6d | most re|cent num|
|00001af0| 65 72 69 63 61 6c 20 65 | 6e 74 72 79 20 69 6e 74 |erical e|ntry int|
|00001b00| 6f 20 69 74 73 20 72 65 | 63 61 6c 63 75 6c 61 74 |o its re|calculat|
|00001b10| 69 6f 6e 3b 20 74 68 65 | 73 65 20 6f 63 63 61 73 |ion; the|se occas|
|00001b20| 69 6f 6e 73 20 0a 61 72 | 65 20 77 68 65 6e 20 49 |ions .ar|e when I|
|00001b30| 20 75 73 65 20 3c 43 74 | 72 6c a0 46 47 53 3e 20 | use <Ct|rl.FGS> |
|00001b40| 74 6f 20 53 61 76 65 20 | 61 20 6c 61 72 67 65 20 |to Save |a large |
|00001b50| 73 68 65 65 74 20 77 68 | 69 63 68 20 68 61 73 20 |sheet wh|ich has |
|00001b60| 6e 6f 74 20 66 69 6e 69 | 73 68 65 64 20 0a 72 65 |not fini|shed .re|
|00001b70| 63 61 6c 63 75 6c 61 74 | 69 6e 67 2e 20 20 47 65 |calculat|ing. Ge|
|00001b80| 6e 65 72 61 6c 6c 79 20 | 50 69 70 65 44 72 65 61 |nerally |PipeDrea|
|00001b90| 6d 20 70 75 74 73 20 69 | 74 73 65 6c 66 20 72 69 |m puts i|tself ri|
|00001ba0| 67 68 74 20 61 74 20 74 | 68 65 20 6e 65 78 74 20 |ght at t|he next |
|00001bb0| 65 6e 74 72 79 20 0a 73 | 6f 20 49 20 75 73 75 61 |entry .s|o I usua|
|00001bc0| 6c 6c 79 20 64 6f 6e 27 | 74 20 62 6f 74 68 65 72 |lly don'|t bother|
|00001bd0| 20 77 6f 72 72 79 69 6e | 67 20 61 62 6f 75 74 20 | worryin|g about |
|00001be0| 69 74 20 75 6e 74 69 6c | 20 49 20 68 61 76 65 20 |it until| I have |
|00001bf0| 63 6f 6d 70 6c 65 74 65 | 64 20 61 6c 6c 20 0a 6d |complete|d all .m|
|00001c00| 79 20 74 72 61 6e 73 61 | 63 74 69 6f 6e 73 2e 20 |y transa|ctions. |
|00001c10| 20 4d 79 20 6d 61 69 6e | 20 63 68 65 63 6b 20 69 | My main| check i|
|00001c20| 73 20 74 6f 20 65 6e 74 | 65 72 20 61 6c 6c 20 74 |s to ent|er all t|
|00001c30| 72 61 6e 73 61 63 74 69 | 6f 6e 73 20 69 6e 74 6f |ransacti|ons into|
|00001c40| 20 61 20 0a 73 65 70 61 | 72 61 74 65 20 73 69 6d | a .sepa|rate sim|
|00001c50| 70 6c 65 20 28 63 72 65 | 64 69 74 2c 20 64 65 62 |ple (cre|dit, deb|
|00001c60| 69 74 2c 20 62 61 6c 61 | 6e 63 65 29 20 66 69 6c |it, bala|nce) fil|
|00001c70| 65 20 61 73 20 49 20 67 | 6f 20 61 6e 64 20 63 68 |e as I g|o and ch|
|00001c80| 65 63 6b 20 74 68 61 74 | 20 0a 74 68 65 20 66 69 |eck that| .the fi|
|00001c90| 6e 61 6c 20 62 61 6c 61 | 6e 63 65 20 61 67 72 65 |nal bala|nce agre|
|00001ca0| 65 73 20 77 69 74 68 20 | 74 68 65 20 6d 61 69 6e |es with |the main|
|00001cb0| 20 28 6c 61 72 67 65 29 | 20 73 70 72 65 61 64 73 | (large)| spreads|
|00001cc0| 68 65 65 74 2e 20 20 54 | 68 69 73 20 69 73 20 0a |heet. T|his is .|
|00001cd0| 6e 6f 74 20 61 20 27 43 | 72 6f 73 73 20 43 68 65 |not a 'C|ross Che|
|00001ce0| 63 6b 27 20 69 6e 20 74 | 68 65 20 27 77 68 65 6e |ck' in t|he 'when|
|00001cf0| 20 49 20 77 61 73 20 65 | 69 67 68 74 27 20 73 65 | I was e|ight' se|
|00001d00| 6e 73 65 20 6f 66 20 74 | 68 65 20 70 68 72 61 73 |nse of t|he phras|
|00001d10| 65 20 62 75 74 20 0a 69 | 74 20 69 73 20 61 20 75 |e but .i|t is a u|
|00001d20| 73 65 66 75 6c 20 77 61 | 79 20 6f 66 20 65 6e 73 |seful wa|y of ens|
|00001d30| 75 72 69 6e 67 20 74 68 | 61 74 20 61 6c 6c 20 65 |uring th|at all e|
|00001d40| 6e 74 72 69 65 73 20 68 | 61 76 65 20 62 65 65 6e |ntries h|ave been|
|00001d50| 20 6d 61 64 65 20 0a 63 | 6f 72 72 65 63 74 6c 79 | made .c|orrectly|
|00001d60| 20 61 6e 64 20 68 61 76 | 65 20 62 65 65 6e 20 27 | and hav|e been '|
|00001d70| 63 61 6c 63 75 6c 61 74 | 65 64 27 20 62 79 20 74 |calculat|ed' by t|
|00001d80| 68 65 20 6d 61 69 6e 20 | 73 70 72 65 61 64 73 68 |he main |spreadsh|
|00001d90| 65 65 74 2e 0a 0a 46 72 | 6f 6d 20 6d 79 20 63 6f |eet...Fr|om my co|
|00001da0| 6d 6d 65 6e 74 73 20 61 | 62 6f 76 65 20 74 68 65 |mments a|bove the|
|00001db0| 20 6d 6f 72 65 20 70 65 | 72 63 65 70 74 69 76 65 | more pe|rceptive|
|00001dc0| 20 6f 66 20 79 6f 75 20 | 77 69 6c 6c 20 72 65 61 | of you |will rea|
|00001dd0| 6c 69 73 65 20 74 68 61 | 74 2c 20 0a 61 6c 74 68 |lise tha|t, .alth|
|00001de0| 6f 75 67 68 20 49 20 68 | 61 76 65 20 62 6f 74 68 |ough I h|ave both|
|00001df0| 2c 20 49 20 73 74 69 6c | 6c 20 75 73 65 20 50 69 |, I stil|l use Pi|
|00001e00| 70 65 44 72 65 61 6d 20 | 69 6e 20 70 72 65 66 65 |peDream |in prefe|
|00001e10| 72 65 6e 63 65 20 74 6f | 20 46 69 72 65 77 6f 72 |rence to| Firewor|
|00001e20| 6b 7a 20 0a 66 6f 72 20 | 74 68 65 20 6d 61 69 6e |kz .for |the main|
|00001e30| 20 70 61 72 74 20 6f 66 | 20 6d 79 20 73 65 72 69 | part of| my seri|
|00001e40| 6f 75 73 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |ous spre|adsheet |
|00001e50| 77 6f 72 6b 2e 20 20 55 | 6e 72 65 70 6f 72 74 65 |work. U|nreporte|
|00001e60| 64 20 65 72 72 6f 72 73 | 20 69 6e 20 0a 46 69 72 |d errors| in .Fir|
|00001e70| 65 77 6f 72 6b 7a 20 69 | 73 20 6f 6e 6c 79 20 70 |eworkz i|s only p|
|00001e80| 61 72 74 20 6f 66 20 74 | 68 65 20 72 65 61 73 6f |art of t|he reaso|
|00001e90| 6e 20 2d 20 74 68 65 20 | 72 65 6c 61 74 69 76 65 |n - the |relative|
|00001ea0| 20 73 70 65 65 64 73 20 | 6f 66 20 50 69 70 65 44 | speeds |of PipeD|
|00001eb0| 72 65 61 6d 20 0a 61 6e | 64 20 46 69 72 65 77 6f |ream .an|d Firewo|
|00001ec0| 72 6b 7a 20 69 73 20 61 | 6e 6f 74 68 65 72 2e 20 |rkz is a|nother. |
|00001ed0| 20 49 20 77 6f 6e 64 65 | 72 20 68 6f 77 20 79 6f | I wonde|r how yo|
|00001ee0| 75 20 66 65 65 6c 20 61 | 62 6f 75 74 20 46 69 72 |u feel a|bout Fir|
|00001ef0| 65 77 6f 72 6b 7a 20 77 | 68 65 6e 20 0a 79 6f 75 |eworkz w|hen .you|
|00001f00| 20 63 6f 6d 70 61 72 65 | 20 69 74 20 77 69 74 68 | compare| it with|
|00001f10| 20 50 69 70 65 44 72 65 | 61 6d 3f 0a 0a 0a 43 72 | PipeDre|am?...Cr|
|00001f20| 6f 73 73 20 43 68 65 63 | 6b 73 0a 0a 4c 6f 61 64 |oss Chec|ks..Load|
|00001f30| 20 74 68 65 20 66 69 6c | 65 20 5b 45 72 72 6f 72 | the fil|e [Error|
|00001f40| 43 68 65 63 6b 5d 20 66 | 72 6f 6d 20 74 68 69 73 |Check] f|rom this|
|00001f50| 20 64 69 72 65 63 74 6f | 72 79 20 61 6e 64 20 79 | directo|ry and y|
|00001f60| 6f 75 20 77 69 6c 6c 20 | 73 65 65 20 74 68 61 74 |ou will |see that|
|00001f70| 20 0a 74 68 65 20 62 6c | 6f 63 6b 20 42 35 45 38 | .the bl|ock B5E8|
|00001f80| 20 63 6f 6e 73 69 73 74 | 73 20 6f 66 20 73 69 78 | consist|s of six|
|00001f90| 74 65 65 6e 20 65 6e 74 | 72 69 65 73 2c 20 61 6c |teen ent|ries, al|
|00001fa0| 6c 20 6f 66 20 77 68 69 | 63 68 20 61 72 65 20 77 |l of whi|ch are w|
|00001fb0| 68 61 74 2c 20 61 73 20 | 0a 61 6e 20 65 69 67 68 |hat, as |.an eigh|
|00001fc0| 74 20 79 65 61 72 20 6f | 6c 64 2c 20 49 20 77 6f |t year o|ld, I wo|
|00001fd0| 75 6c 64 20 68 61 76 65 | 20 63 61 6c 6c 65 64 20 |uld have| called |
|00001fe0| 22 64 65 63 69 6d 61 6c | 73 22 20 62 75 74 20 77 |"decimal|s" but w|
|00001ff0| 68 69 63 68 20 49 20 62 | 65 6c 69 65 76 65 20 0a |hich I b|elieve .|
|00002000| 61 72 65 20 6e 6f 77 20 | 63 61 6c 6c 65 64 20 22 |are now |called "|
|00002010| 64 65 63 69 6d 61 6c 20 | 66 72 61 63 74 69 6f 6e |decimal |fraction|
|00002020| 73 22 2e 0a 0a 54 68 65 | 20 73 75 6d 73 20 6f 66 |s"...The| sums of|
|00002030| 20 74 68 65 20 63 6f 6c | 75 6d 6e 73 20 61 70 70 | the col|umns app|
|00002040| 65 61 72 20 69 6e 20 72 | 6f 77 20 31 30 20 61 6e |ear in r|ow 10 an|
|00002050| 64 20 74 68 65 20 73 75 | 6d 73 20 6f 66 20 74 68 |d the su|ms of th|
|00002060| 65 20 72 6f 77 73 20 0a | 61 70 70 65 61 72 20 69 |e rows .|appear i|
|00002070| 6e 20 63 6f 6c 75 6d 6e | 20 47 2e 20 20 49 66 20 |n column| G. If |
|00002080| 79 6f 75 20 74 68 65 6e | 20 61 64 64 20 74 68 65 |you then| add the|
|00002090| 20 76 61 6c 75 65 73 20 | 69 6e 20 72 6f 77 20 31 | values |in row 1|
|000020a0| 30 2c 20 42 31 30 45 31 | 30 2c 20 69 74 20 0a 73 |0, B10E1|0, it .s|
|000020b0| 68 6f 75 6c 64 20 62 65 | 20 28 65 78 61 63 74 6c |hould be| (exactl|
|000020c0| 79 29 20 74 68 65 20 73 | 61 6d 65 20 61 73 20 74 |y) the s|ame as t|
|000020d0| 68 65 20 73 75 6d 20 6f | 66 20 63 6f 6c 75 6d 6e |he sum o|f column|
|000020e0| 20 47 2c 20 47 35 47 38 | 2e 0a 0a 57 68 65 6e 20 | G, G5G8|...When |
|000020f0| 49 20 77 61 73 20 65 69 | 67 68 74 20 79 65 61 72 |I was ei|ght year|
|00002100| 73 20 6f 6c 64 20 74 68 | 69 73 20 22 43 72 6f 73 |s old th|is "Cros|
|00002110| 73 20 43 68 65 63 6b 20 | 41 72 69 74 68 6d 65 74 |s Check |Arithmet|
|00002120| 69 63 22 20 69 73 20 73 | 6f 6d 65 74 68 69 6e 67 |ic" is s|omething|
|00002130| 20 49 20 0a 68 61 64 20 | 74 6f 20 70 72 61 63 74 | I .had |to pract|
|00002140| 69 63 65 20 66 6f 72 20 | 68 6f 75 72 73 20 6f 6e |ice for |hours on|
|00002150| 20 65 6e 64 20 28 77 69 | 74 68 6f 75 74 20 74 68 | end (wi|thout th|
|00002160| 65 20 61 69 64 20 6f 66 | 20 61 20 63 61 6c 63 75 |e aid of| a calcu|
|00002170| 6c 61 74 6f 72 29 2e 20 | 20 0a 49 6e 63 69 64 65 |lator). | .Incide|
|00002180| 6e 74 61 6c 6c 79 20 49 | 20 66 6f 75 6e 64 20 74 |ntally I| found t|
|00002190| 68 61 74 20 61 64 64 69 | 6e 67 20 63 6f 6c 75 6d |hat addi|ng colum|
|000021a0| 6e 73 20 77 61 73 20 6d | 75 63 68 20 65 61 73 69 |ns was m|uch easi|
|000021b0| 65 72 20 74 68 61 6e 20 | 61 64 64 69 6e 67 20 0a |er than |adding .|
|000021c0| 61 6c 6f 6e 67 20 61 20 | 72 6f 77 20 2d 20 65 76 |along a |row - ev|
|000021d0| 65 6e 20 74 68 6f 75 67 | 68 20 49 20 68 61 64 20 |en thoug|h I had |
|000021e0| 6e 65 76 65 72 20 68 65 | 61 72 64 20 6f 66 20 28 |never he|ard of (|
|000021f0| 74 6f 20 75 73 65 20 6d | 6f 64 65 72 6e 20 0a 74 |to use m|odern .t|
|00002200| 65 72 6d 69 6e 6f 6c 6f | 67 79 29 20 27 70 6c 61 |erminolo|gy) 'pla|
|00002210| 63 65 20 6e 6f 74 61 74 | 69 6f 6e 27 2e 20 20 49 |ce notat|ion'. I|
|00002220| 20 74 6f 6f 6b 20 74 6f | 20 64 6f 69 6e 67 20 77 | took to| doing w|
|00002230| 68 61 74 20 49 20 6e 6f | 77 20 6b 6e 6f 77 20 61 |hat I no|w know a|
|00002240| 73 20 0a 27 74 72 61 6e | 73 70 6f 73 69 6e 67 27 |s .'tran|sposing'|
|00002250| 20 74 68 65 20 61 72 72 | 61 79 20 6f 66 20 6e 75 | the arr|ay of nu|
|00002260| 6d 62 65 72 73 20 28 73 | 6f 20 74 68 61 74 20 74 |mbers (s|o that t|
|00002270| 68 65 20 72 6f 77 73 20 | 62 65 63 61 6d 65 20 63 |he rows |became c|
|00002280| 6f 6c 75 6d 6e 73 20 61 | 6e 64 20 0a 74 68 65 20 |olumns a|nd .the |
|00002290| 63 6f 6c 75 6d 6e 73 20 | 62 65 63 61 6d 65 20 72 |columns |became r|
|000022a0| 6f 77 73 29 20 61 6e 64 | 20 61 64 64 69 6e 67 20 |ows) and| adding |
|000022b0| 6f 6e 6c 79 20 63 6f 6c | 75 6d 6e 73 2e 20 20 49 |only col|umns. I|
|000022c0| 20 66 6f 75 6e 64 20 74 | 68 61 74 20 74 68 65 20 | found t|hat the |
|000022d0| 0a 74 69 6d 65 20 74 61 | 6b 65 6e 20 74 6f 20 72 |.time ta|ken to r|
|000022e0| 65 77 72 69 74 65 20 74 | 68 65 20 61 72 72 61 79 |ewrite t|he array|
|000022f0| 20 69 6e 20 69 74 73 20 | 74 72 61 6e 73 70 6f 73 | in its |transpos|
|00002300| 65 64 20 66 6f 72 6d 20 | 77 61 73 20 6d 6f 72 65 |ed form |was more|
|00002310| 20 74 68 61 6e 20 0a 63 | 6f 6d 70 65 6e 73 61 74 | than .c|ompensat|
|00002320| 65 64 20 66 6f 72 20 62 | 79 20 74 68 65 20 74 69 |ed for b|y the ti|
|00002330| 6d 65 20 74 61 6b 65 6e | 20 74 6f 20 63 6f 72 72 |me taken| to corr|
|00002340| 65 63 74 6c 79 20 61 64 | 64 20 75 70 20 74 68 65 |ectly ad|d up the|
|00002350| 20 72 6f 77 73 2e 20 20 | 49 20 0a 73 75 70 70 6f | rows. |I .suppo|
|00002360| 73 65 20 74 68 61 74 2c | 20 77 69 74 68 20 61 20 |se that,| with a |
|00002370| 63 61 6c 63 75 6c 61 74 | 6f 72 2c 20 69 74 20 64 |calculat|or, it d|
|00002380| 6f 65 73 6e 27 74 20 6d | 61 6b 65 20 61 20 6c 6f |oesn't m|ake a lo|
|00002390| 74 20 6f 66 20 64 69 66 | 66 65 72 65 6e 63 65 20 |t of dif|ference |
|000023a0| 0a 77 68 65 74 68 65 72 | 20 79 6f 75 27 72 65 20 |.whether| you're |
|000023b0| 61 64 64 69 6e 67 20 64 | 6f 77 6e 20 61 20 63 6f |adding d|own a co|
|000023c0| 6c 75 6d 6e 20 6f 72 20 | 61 6c 6f 6e 67 20 61 20 |lumn or |along a |
|000023d0| 72 6f 77 2e 20 20 53 75 | 63 68 20 69 73 20 70 72 |row. Su|ch is pr|
|000023e0| 6f 67 72 65 73 73 21 0a | 0a 42 65 66 6f 72 65 20 |ogress!.|.Before |
|000023f0| 49 20 69 6e 74 72 6f 64 | 75 63 65 20 79 6f 75 20 |I introd|uce you |
|00002400| 74 6f 20 74 68 65 20 66 | 6f 72 6d 75 6c 61 65 20 |to the f|ormulae |
|00002410| 69 6e 20 48 31 30 2c 20 | 49 31 30 20 61 6e 64 20 |in H10, |I10 and |
|00002420| 4a 31 30 20 6c 65 74 20 | 6d 65 20 64 72 61 77 20 |J10 let |me draw |
|00002430| 0a 79 6f 75 72 20 61 74 | 74 65 6e 74 69 6f 6e 20 |.your at|tention |
|00002440| 74 6f 20 61 20 73 75 62 | 74 6c 65 20 70 6f 69 6e |to a sub|tle poin|
|00002450| 74 20 61 62 6f 75 74 20 | 74 68 65 20 66 6f 72 6d |t about |the form|
|00002460| 75 6c 61 65 20 69 6e 20 | 72 6f 77 20 31 30 20 61 |ulae in |row 10 a|
|00002470| 6e 64 20 0a 63 6f 6c 75 | 6d 6e 20 47 2e 20 20 46 |nd .colu|mn G. F|
|00002480| 6f 72 20 65 78 61 6d 70 | 6c 65 2c 20 68 61 76 65 |or examp|le, have|
|00002490| 20 61 20 6c 6f 6f 6b 20 | 61 74 20 42 31 30 20 77 | a look |at B10 w|
|000024a0| 68 65 72 65 20 79 6f 75 | 20 77 69 6c 6c 20 66 69 |here you| will fi|
|000024b0| 6e 64 20 0a 73 75 6d 28 | 42 34 42 39 29 20 61 6e |nd .sum(|B4B9) an|
|000024c0| 64 20 6e 6f 74 20 73 75 | 6d 28 42 35 42 38 29 20 |d not su|m(B5B8) |
|000024d0| 61 73 20 79 6f 75 20 6d | 69 67 68 74 20 68 61 76 |as you m|ight hav|
|000024e0| 65 20 65 78 70 65 63 74 | 65 64 2e 20 20 57 68 61 |e expect|ed. Wha|
|000024f0| 74 20 49 20 68 61 76 65 | 20 0a 64 6f 6e 65 20 69 |t I have| .done i|
|00002500| 73 20 74 6f 20 69 6e 74 | 72 6f 64 75 63 65 20 74 |s to int|roduce t|
|00002510| 77 6f 20 62 6c 61 6e 6b | 20 72 6f 77 73 2c 20 72 |wo blank| rows, r|
|00002520| 6f 77 20 34 20 61 6e 64 | 20 72 6f 77 20 39 20 61 |ow 4 and| row 9 a|
|00002530| 6e 64 20 69 6e 63 6c 75 | 64 65 20 74 68 65 6d 20 |nd inclu|de them |
|00002540| 0a 69 6e 20 74 68 65 20 | 73 75 6d 28 29 2e 20 20 |.in the |sum(). |
|00002550| 59 6f 75 20 6d 69 67 68 | 74 20 77 6f 6e 64 65 72 |You migh|t wonder|
|00002560| 20 77 68 79 2e 20 20 54 | 68 65 20 72 65 61 73 6f | why. T|he reaso|
|00002570| 6e 20 69 73 20 74 68 61 | 74 2c 20 69 66 20 79 6f |n is tha|t, if yo|
|00002580| 75 20 64 6f 20 69 74 20 | 0a 6d 79 20 77 61 79 2c |u do it |.my way,|
|00002590| 20 79 6f 75 20 63 61 6e | 20 6d 61 72 6b 20 74 68 | you can| mark th|
|000025a0| 65 20 72 6f 77 73 20 35 | 20 74 6f 20 38 20 28 63 |e rows 5| to 8 (c|
|000025b0| 6f 6e 74 61 69 6e 69 6e | 67 20 74 68 65 20 64 61 |ontainin|g the da|
|000025c0| 74 61 29 20 61 6e 64 20 | 75 73 65 20 61 20 0a 53 |ta) and |use a .S|
|000025d0| 6f 72 74 20 6f 70 65 72 | 61 74 69 6f 6e 20 28 73 |ort oper|ation (s|
|000025e0| 75 63 68 20 61 73 20 3c | 43 74 72 6c a0 42 53 4f |uch as <|Ctrl.BSO|
|000025f0| 3e 29 20 6f 6e 20 74 68 | 65 20 6d 61 72 6b 65 64 |>) on th|e marked|
|00002600| 20 62 6c 6f 63 6b 20 77 | 69 74 68 6f 75 74 20 0a | block w|ithout .|
|00002610| 27 63 6f 72 72 75 70 74 | 69 6e 67 27 20 74 68 65 |'corrupt|ing' the|
|00002620| 20 66 6f 72 6d 75 6c 61 | 20 69 6e 20 42 31 30 2e | formula| in B10.|
|00002630| 20 20 49 66 20 79 6f 75 | 20 75 73 65 64 20 74 68 | If you| used th|
|00002640| 65 20 66 6f 72 6d 75 6c | 61 20 73 75 6d 28 42 35 |e formul|a sum(B5|
|00002650| 42 38 29 20 69 6e 20 0a | 42 31 30 20 61 6e 64 20 |B8) in .|B10 and |
|00002660| 74 68 65 6e 20 73 6f 72 | 74 65 64 20 74 68 65 20 |then sor|ted the |
|00002670| 62 6c 6f 63 6b 20 69 6e | 20 73 75 63 68 20 61 20 |block in| such a |
|00002680| 77 61 79 20 74 68 61 74 | 20 72 6f 77 20 38 20 63 |way that| row 8 c|
|00002690| 68 61 6e 67 65 64 20 70 | 6f 73 69 74 69 6f 6e 20 |hanged p|osition |
|000026a0| 0a 74 6f 20 62 65 63 6f | 6d 65 2c 20 73 61 79 20 |.to beco|me, say |
|000026b0| 72 6f 77 20 37 20 74 68 | 65 6e 20 74 68 65 20 73 |row 7 th|en the s|
|000026c0| 75 6d 28 42 35 42 38 29 | 20 77 6f 75 6c 64 20 62 |um(B5B8)| would b|
|000026d0| 65 20 27 63 6f 72 72 75 | 70 74 65 64 27 20 74 6f |e 'corru|pted' to|
|000026e0| 20 62 65 63 6f 6d 65 20 | 0a 73 75 6d 28 42 35 42 | become |.sum(B5B|
|000026f0| 37 29 2c 20 77 68 69 63 | 68 20 79 6f 75 20 64 6f |7), whic|h you do|
|00002700| 6e 27 74 20 77 61 6e 74 | 20 74 6f 20 68 61 70 70 |n't want| to happ|
|00002710| 65 6e 20 62 65 63 61 75 | 73 65 20 74 68 65 20 6e |en becau|se the n|
|00002720| 65 77 20 72 6f 77 20 38 | 20 77 6f 75 6c 64 20 0a |ew row 8| would .|
|00002730| 62 65 20 6c 65 66 74 20 | 6f 75 74 20 6f 66 20 74 |be left |out of t|
|00002740| 68 65 20 73 75 6d 21 20 | 20 49 74 20 69 73 20 27 |he sum! | It is '|
|00002750| 67 6f 6f 64 20 70 72 61 | 63 74 69 63 65 27 20 74 |good pra|ctice' t|
|00002760| 6f 20 6c 65 61 76 65 20 | 62 6c 61 6e 6b 20 6c 69 |o leave |blank li|
|00002770| 6e 65 73 20 0a 61 62 6f | 76 65 2c 20 62 65 6c 6f |nes .abo|ve, belo|
|00002780| 77 2c 20 6c 65 66 74 20 | 61 6e 64 20 72 69 67 68 |w, left |and righ|
|00002790| 74 20 6f 66 20 61 20 62 | 6c 6f 63 6b 20 6f 66 20 |t of a b|lock of |
|000027a0| 64 61 74 61 20 66 6f 72 | 20 74 68 69 73 20 72 65 |data for| this re|
|000027b0| 61 73 6f 6e 2e 0a 0a 54 | 68 6f 73 65 20 6f 66 20 |ason...T|hose of |
|000027c0| 79 6f 75 20 77 68 6f 20 | 63 72 65 61 74 65 20 64 |you who |create d|
|000027d0| 61 74 61 20 62 61 73 65 | 73 20 6f 66 20 74 65 78 |ata base|s of tex|
|000027e0| 74 20 77 69 74 68 20 65 | 61 63 68 20 72 6f 77 20 |t with e|ach row |
|000027f0| 61 20 72 65 63 6f 72 64 | 20 61 6e 64 20 0a 65 61 |a record| and .ea|
|00002800| 63 68 20 63 6f 6c 75 6d | 6e 20 61 20 66 69 65 6c |ch colum|n a fiel|
|00002810| 64 20 77 6f 75 6c 64 20 | 64 6f 20 77 65 6c 6c 20 |d would |do well |
|00002820| 74 6f 20 6e 6f 74 65 20 | 74 68 69 73 20 27 74 69 |to note |this 'ti|
|00002830| 70 27 20 6f 66 20 6c 65 | 61 76 69 6e 67 20 61 20 |p' of le|aving a |
|00002840| 62 6c 61 6e 6b 20 0a 6c | 69 6e 65 20 69 6e 20 61 |blank .l|ine in a|
|00002850| 6e 79 20 63 6f 6d 70 75 | 74 61 74 69 6f 6e 20 6f |ny compu|tation o|
|00002860| 6e 20 74 68 65 20 63 6f | 6c 75 6d 6e 73 2e 0a 0a |n the co|lumns...|
|00002870| 41 73 20 61 6e 20 61 73 | 69 64 65 20 2d 20 49 20 |As an as|ide - I |
|00002880| 74 68 69 6e 6b 20 69 74 | 20 69 73 20 67 6f 6f 64 |think it| is good|
|00002890| 20 70 72 61 63 74 69 63 | 65 20 74 6f 20 69 6e 63 | practic|e to inc|
|000028a0| 6c 75 64 65 20 62 6c 61 | 6e 6b 20 72 6f 77 73 20 |lude bla|nk rows |
|000028b0| 61 6e 64 20 0a 63 6f 6c | 75 6d 6e 73 20 77 68 65 |and .col|umns whe|
|000028c0| 6e 20 64 65 66 69 6e 69 | 6e 67 20 61 20 50 69 70 |n defini|ng a Pip|
|000028d0| 65 44 72 65 61 6d 20 4e | 61 6d 65 20 74 6f 20 72 |eDream N|ame to r|
|000028e0| 65 66 65 72 20 74 6f 20 | 61 20 62 6c 6f 63 6b 20 |efer to |a block |
|000028f0| 6f 66 20 64 61 74 61 20 | 69 66 20 0a 74 68 65 72 |of data |if .ther|
|00002900| 65 20 69 73 20 61 6e 79 | 20 63 68 61 6e 63 65 20 |e is any| chance |
|00002910| 79 6f 75 27 72 65 20 67 | 6f 69 6e 67 20 74 6f 20 |you're g|oing to |
|00002920| 73 6f 72 74 20 69 74 2e | 0a 0a 0a 54 68 65 20 45 |sort it.|...The E|
|00002930| 72 72 6f 6e 65 6f 75 73 | 20 43 72 6f 73 73 20 43 |rroneous| Cross C|
|00002940| 68 65 63 6b 0a 0a 54 68 | 65 20 27 6f 62 76 69 6f |heck..Th|e 'obvio|
|00002950| 75 73 27 20 63 72 6f 73 | 73 20 63 68 65 63 6b 20 |us' cros|s check |
|00002960| 66 6f 72 6d 75 6c 61 20 | 69 73 20 74 68 61 74 20 |formula |is that |
|00002970| 69 6e 20 73 6c 6f 74 20 | 48 31 30 2e 20 20 53 75 |in slot |H10. Su|
|00002980| 72 70 72 69 73 69 6e 67 | 6c 79 20 69 74 20 0a 67 |rprising|ly it .g|
|00002990| 69 76 65 73 20 74 68 65 | 20 6d 65 73 73 61 67 65 |ives the| message|
|000029a0| 20 22 45 72 72 6f 72 22 | 21 20 20 54 68 65 20 72 | "Error"|! The r|
|000029b0| 65 61 73 6f 6e 20 69 73 | 20 69 6e 74 65 72 65 73 |eason is| interes|
|000029c0| 74 69 6e 67 20 61 6e 64 | 20 49 20 68 61 76 65 20 |ting and| I have |
|000029d0| 0a 72 65 66 65 72 72 65 | 64 20 74 6f 20 69 74 20 |.referre|d to it |
|000029e0| 69 6e 20 65 61 72 6c 69 | 65 72 20 61 72 74 69 63 |in earli|er artic|
|000029f0| 6c 65 73 2e 20 20 45 73 | 73 65 6e 74 69 61 6c 6c |les. Es|sentiall|
|00002a00| 79 2c 20 64 65 63 69 6d | 61 6c 20 66 72 61 63 74 |y, decim|al fract|
|00002a10| 69 6f 6e 73 20 61 72 65 | 20 0a 6e 6f 74 20 28 61 |ions are| .not (a|
|00002a20| 6e 64 20 63 61 6e 20 6e | 6f 74 29 20 62 65 20 73 |nd can n|ot) be s|
|00002a30| 74 6f 72 65 64 20 61 63 | 63 75 72 61 74 65 6c 79 |tored ac|curately|
|00002a40| 20 69 6e 20 62 69 6e 61 | 72 79 20 28 74 68 6f 75 | in bina|ry (thou|
|00002a50| 67 68 20 74 68 65 79 20 | 63 61 6e 20 62 65 20 0a |gh they |can be .|
|00002a60| 73 74 6f 72 65 64 20 61 | 63 63 75 72 61 74 65 6c |stored a|ccuratel|
|00002a70| 79 20 69 6e 20 62 69 6e | 61 72 79 20 63 6f 64 65 |y in bin|ary code|
|00002a80| 64 20 64 65 63 69 6d 61 | 6c 29 20 73 69 6e 63 65 |d decima|l) since|
|00002a90| 20 61 20 6e 75 6d 62 65 | 72 20 73 75 63 68 20 61 | a numbe|r such a|
|00002aa0| 73 20 74 68 65 0a 64 65 | 63 69 6d 61 6c 20 30 2e |s the.de|cimal 0.|
|00002ab0| 31 20 69 73 20 61 20 6e | 6f 6e 20 74 65 72 6d 69 |1 is a n|on termi|
|00002ac0| 6e 61 74 69 6e 67 20 73 | 65 72 69 65 73 20 6f 66 |nating s|eries of|
|00002ad0| 20 31 20 61 6e 64 20 30 | 20 69 6e 20 62 69 6e 61 | 1 and 0| in bina|
|00002ae0| 72 79 2e 20 20 41 74 20 | 74 68 69 73 20 0a 73 74 |ry. At |this .st|
|00002af0| 61 67 65 20 49 20 6d 75 | 73 74 20 61 63 6b 6e 6f |age I mu|st ackno|
|00002b00| 77 6c 65 64 67 65 20 74 | 68 65 20 6d 61 6e 79 20 |wledge t|he many |
|00002b10| 63 6f 72 72 65 73 70 6f | 6e 64 65 6e 74 73 20 77 |correspo|ndents w|
|00002b20| 68 6f 20 68 61 76 65 20 | 77 72 69 74 74 65 6e 20 |ho have |written |
|00002b30| 74 6f 20 0a 6d 65 2c 20 | 6d 61 6e 79 20 73 65 6e |to .me, |many sen|
|00002b40| 64 69 6e 67 20 6d 65 20 | 61 20 77 6f 72 6b 65 64 |ding me |a worked|
|00002b50| 20 76 61 6c 75 65 20 66 | 6f 72 20 31 a0 f7 a0 31 | value f|or 1...1|
|00002b60| 30 20 75 73 69 6e 67 20 | 62 69 6e 61 72 79 20 6c |0 using |binary l|
|00002b70| 6f 6e 67 20 0a 64 69 76 | 69 73 69 6f 6e 2e 20 20 |ong .div|ision. |
|00002b80| 54 68 65 20 69 6e 66 69 | 6e 69 74 65 20 73 65 72 |The infi|nite ser|
|00002b90| 69 65 73 20 6f 66 20 28 | 62 69 6e 61 72 79 29 20 |ies of (|binary) |
|00002ba0| 31 20 61 6e 64 20 30 20 | 68 61 73 20 74 6f 20 62 |1 and 0 |has to b|
|00002bb0| 65 20 74 72 75 6e 63 61 | 74 65 64 20 0a 61 74 20 |e trunca|ted .at |
|00002bc0| 73 6f 6d 65 20 70 6f 69 | 6e 74 2e 20 20 54 68 69 |some poi|nt. Thi|
|00002bd0| 73 20 74 72 75 6e 63 61 | 74 69 6f 6e 20 67 65 6e |s trunca|tion gen|
|00002be0| 65 72 61 74 65 73 20 74 | 68 65 20 27 69 6e 61 63 |erates t|he 'inac|
|00002bf0| 63 75 72 61 63 79 27 20 | 77 69 74 68 20 77 68 69 |curacy' |with whi|
|00002c00| 63 68 20 0a 76 61 6c 75 | 65 73 20 73 75 63 68 20 |ch .valu|es such |
|00002c10| 61 73 20 30 2e 31 20 61 | 72 65 20 73 74 6f 72 65 |as 0.1 a|re store|
|00002c20| 64 20 69 6e 20 74 68 65 | 20 63 6f 6d 70 75 74 65 |d in the| compute|
|00002c30| 72 2e 0a 0a 57 68 65 74 | 68 65 72 20 6f 72 20 6e |r...Whet|her or n|
|00002c40| 6f 74 20 79 6f 75 20 66 | 6f 6c 6c 6f 77 20 74 68 |ot you f|ollow th|
|00002c50| 65 20 72 65 61 73 6f 6e | 69 6e 67 20 6f 66 20 74 |e reason|ing of t|
|00002c60| 68 65 20 70 72 65 76 69 | 6f 75 73 20 70 61 72 61 |he previ|ous para|
|00002c70| 67 72 61 70 68 2c 20 74 | 68 65 20 0a 65 73 73 65 |graph, t|he .esse|
|00002c80| 6e 74 69 61 6c 20 70 6f | 69 6e 74 20 74 6f 20 67 |ntial po|int to g|
|00002c90| 72 61 73 70 20 69 73 20 | 74 68 61 74 20 74 68 65 |rasp is |that the|
|00002ca0| 20 73 75 6d 20 6f 66 20 | 74 68 65 20 76 61 6c 75 | sum of |the valu|
|00002cb0| 65 73 20 69 6e 20 72 6f | 77 20 31 30 20 69 73 20 |es in ro|w 10 is |
|00002cc0| 61 20 0a 73 75 6d 20 6f | 66 20 61 70 70 72 6f 78 |a .sum o|f approx|
|00002cd0| 69 6d 61 74 69 6f 6e 73 | 20 61 6e 64 20 74 68 61 |imations| and tha|
|00002ce0| 74 20 74 68 65 20 73 75 | 6d 20 6f 66 20 74 68 65 |t the su|m of the|
|00002cf0| 20 76 61 6c 75 65 73 20 | 69 6e 20 63 6f 6c 75 6d | values |in colum|
|00002d00| 6e 20 47 20 28 77 68 69 | 63 68 20 0a 69 73 20 61 |n G (whi|ch .is a|
|00002d10| 6c 73 6f 20 61 20 73 75 | 6d 20 6f 66 20 61 70 70 |lso a su|m of app|
|00002d20| 72 6f 78 69 6d 61 74 69 | 6f 6e 73 29 20 63 61 6e |roximati|ons) can|
|00002d30| 20 65 61 73 69 6c 79 20 | 62 65 20 73 6c 69 67 68 | easily |be sligh|
|00002d40| 74 6c 79 20 64 69 66 66 | 65 72 65 6e 74 2e 20 20 |tly diff|erent. |
|00002d50| 54 68 65 20 0a 64 69 73 | 70 6c 61 79 65 64 20 76 |The .dis|played v|
|00002d60| 61 6c 75 65 20 77 6f 6e | 27 74 20 62 65 20 64 69 |alue won|'t be di|
|00002d70| 66 66 65 72 65 6e 74 20 | 62 65 63 61 75 73 65 20 |fferent |because |
|00002d80| 74 68 65 20 64 69 66 66 | 65 72 65 6e 63 65 20 62 |the diff|erence b|
|00002d90| 65 74 77 65 65 6e 20 74 | 68 65 20 0a 74 77 6f 20 |etween t|he .two |
|00002da0| 76 61 6c 75 65 73 20 69 | 73 20 61 20 76 65 72 79 |values i|s a very|
|00002db0| 20 73 6d 61 6c 6c 20 6e | 75 6d 62 65 72 20 28 61 | small n|umber (a|
|00002dc0| 62 6f 75 74 20 30 2e 30 | 30 30 30 30 30 30 30 30 |bout 0.0|00000000|
|00002dd0| 30 30 30 30 30 30 31 29 | 20 61 6e 64 20 74 68 65 |0000001)| and the|
|00002de0| 20 0a 64 69 73 70 6c 61 | 79 20 69 73 20 73 68 6f | .displa|y is sho|
|00002df0| 77 6e 20 6f 6e 6c 79 20 | 74 6f 20 74 77 6f 20 64 |wn only |to two d|
|00002e00| 65 63 69 6d 61 6c 20 70 | 6c 61 63 65 73 2e 20 20 |ecimal p|laces. |
|00002e10| 49 66 20 79 6f 75 72 20 | 27 43 72 6f 73 73 20 43 |If your |'Cross C|
|00002e20| 68 65 63 6b 27 20 69 73 | 20 0a 74 6f 20 63 6f 6d |heck' is| .to com|
|00002e30| 70 61 72 65 20 74 68 65 | 20 74 77 6f 20 61 70 70 |pare the| two app|
|00002e40| 72 6f 78 69 6d 61 74 69 | 6f 6e 73 20 66 6f 72 20 |roximati|ons for |
|00002e50| 61 6e 20 65 78 61 63 74 | 20 6d 61 74 63 68 20 74 |an exact| match t|
|00002e60| 68 65 6e 20 73 6f 6d 65 | 74 69 6d 65 73 20 79 6f |hen some|times yo|
|00002e70| 75 20 0a 77 69 6c 6c 20 | 62 65 20 74 6f 6c 64 20 |u .will |be told |
|00002e80| 74 68 61 74 20 74 68 65 | 72 65 20 69 73 20 61 6e |that the|re is an|
|00002e90| 20 22 45 72 72 6f 72 22 | 20 77 68 65 6e 2c 20 69 | "Error"| when, i|
|00002ea0| 6e 20 74 72 75 74 68 20 | 74 68 65 20 63 61 6c 63 |n truth |the calc|
|00002eb0| 75 6c 61 74 69 6f 6e 20 | 69 73 20 0a 28 6e 65 61 |ulation |is .(nea|
|00002ec0| 72 20 65 6e 6f 75 67 68 | 29 20 22 4f 4b 22 2e 0a |r enough|) "OK"..|
|00002ed0| 0a 0a 41 20 27 50 72 61 | 67 6d 61 74 69 63 27 20 |..A 'Pra|gmatic' |
|00002ee0| 43 72 6f 73 73 20 43 68 | 65 63 6b 0a 0a 4e 6f 77 |Cross Ch|eck..Now|
|00002ef0| 20 68 61 76 65 20 61 20 | 6c 6f 6f 6b 20 69 6e 20 | have a |look in |
|00002f00| 73 6c 6f 74 20 49 31 30 | 20 61 6e 64 20 79 6f 75 |slot I10| and you|
|00002f10| 20 77 69 6c 6c 20 73 65 | 65 20 74 68 65 20 66 6f | will se|e the fo|
|00002f20| 72 6d 75 6c 61 20 77 68 | 69 63 68 20 68 61 73 20 |rmula wh|ich has |
|00002f30| 62 65 65 6e 0a 64 65 76 | 65 6c 6f 70 65 64 20 61 |been.dev|eloped a|
|00002f40| 73 20 61 20 72 65 73 75 | 6c 74 20 6f 66 20 63 6f |s a resu|lt of co|
|00002f50| 72 72 65 73 70 6f 6e 64 | 65 6e 63 65 20 61 62 6f |rrespond|ence abo|
|00002f60| 75 74 20 65 72 72 6f 72 | 20 63 68 65 63 6b 73 20 |ut error| checks |
|00002f70| 62 65 74 77 65 65 6e 20 | 0a 6d 79 73 65 6c 66 20 |between |.myself |
|00002f80| 61 6e 64 20 44 65 6e 6e | 69 73 20 48 6f 77 61 72 |and Denn|is Howar|
|00002f90| 64 2e 20 20 54 68 61 6e | 6b 73 20 44 65 6e 6e 69 |d. Than|ks Denni|
|00002fa0| 73 20 66 6f 72 20 74 68 | 65 20 69 6e 73 70 69 72 |s for th|e inspir|
|00002fb0| 61 74 69 6f 6e 21 0a 0a | 54 68 65 20 64 69 66 66 |ation!..|The diff|
|00002fc0| 65 72 65 6e 63 65 20 62 | 65 74 77 65 65 6e 20 74 |erence b|etween t|
|00002fd0| 68 65 20 74 77 6f 20 76 | 61 6c 75 65 73 20 28 72 |he two v|alues (r|
|00002fe0| 65 6d 65 6d 62 65 72 20 | 74 68 61 74 20 74 68 69 |emember |that thi|
|00002ff0| 73 20 64 69 66 66 65 72 | 65 6e 63 65 20 69 73 20 |s differ|ence is |
|00003000| 0a 74 68 65 6f 72 65 74 | 69 63 61 6c 6c 79 20 7a |.theoret|ically z|
|00003010| 65 72 6f 20 69 66 20 74 | 68 65 20 6e 75 6d 62 65 |ero if t|he numbe|
|00003020| 72 73 20 61 72 65 20 65 | 78 61 63 74 6c 79 20 74 |rs are e|xactly t|
|00003030| 68 65 20 73 61 6d 65 29 | 20 69 73 20 64 69 76 69 |he same)| is divi|
|00003040| 64 65 64 20 62 79 20 0a | 74 77 69 63 65 20 74 68 |ded by .|twice th|
|00003050| 65 69 72 20 61 76 65 72 | 61 67 65 20 61 6e 64 20 |eir aver|age and |
|00003060| 74 68 65 20 61 62 73 6f | 6c 75 74 65 20 76 61 6c |the abso|lute val|
|00003070| 75 65 20 6f 66 20 74 68 | 69 73 20 72 61 74 69 6f |ue of th|is ratio|
|00003080| 20 69 73 20 63 6f 6d 70 | 61 72 65 64 20 0a 77 69 | is comp|ared .wi|
|00003090| 74 68 20 61 20 73 6d 61 | 6c 6c 20 6e 75 6d 62 65 |th a sma|ll numbe|
|000030a0| 72 20 2d 20 69 6e 20 74 | 68 69 73 20 63 61 73 65 |r - in t|his case|
|000030b0| 20 28 31 65 2d 31 30 29 | 20 69 65 20 30 2e 30 30 | (1e-10)| ie 0.00|
|000030c0| 30 30 30 30 30 30 30 31 | 2e 20 20 49 20 68 61 76 |00000001|. I hav|
|000030d0| 65 20 0a 75 73 65 64 20 | 74 68 65 20 66 75 6e 63 |e .used |the func|
|000030e0| 74 69 6f 6e 20 61 62 73 | 28 29 20 74 6f 20 67 65 |tion abs|() to ge|
|000030f0| 74 20 72 69 64 20 6f 66 | 20 61 6e 79 20 6e 65 67 |t rid of| any neg|
|00003100| 61 74 69 76 65 20 76 61 | 6c 75 65 20 66 6f 72 20 |ative va|lue for |
|00003110| 74 68 65 20 0a 64 69 66 | 66 65 72 65 6e 63 65 20 |the .dif|ference |
|00003120| 62 65 66 6f 72 65 20 63 | 6f 6d 70 61 72 69 6e 67 |before c|omparing|
|00003130| 20 69 74 20 77 69 74 68 | 20 74 68 65 20 73 6d 61 | it with| the sma|
|00003140| 6c 6c 20 70 6f 73 69 74 | 69 76 65 20 6e 75 6d 62 |ll posit|ive numb|
|00003150| 65 72 20 28 31 65 2d 31 | 30 29 2e 20 20 0a 54 68 |er (1e-1|0). .Th|
|00003160| 69 73 20 6d 65 74 68 6f | 64 20 6f 66 20 64 69 76 |is metho|d of div|
|00003170| 69 64 69 6e 67 20 74 68 | 65 20 64 69 66 66 65 72 |iding th|e differ|
|00003180| 65 6e 63 65 20 62 79 20 | 28 74 77 69 63 65 29 20 |ence by |(twice) |
|00003190| 74 68 65 20 61 76 65 72 | 61 67 65 20 61 6c 6c 6f |the aver|age allo|
|000031a0| 77 73 20 0a 79 6f 75 20 | 74 6f 20 63 68 65 63 6b |ws .you |to check|
|000031b0| 20 62 6f 74 68 20 6c 61 | 72 67 65 20 61 6e 64 20 | both la|rge and |
|000031c0| 73 6d 61 6c 6c 20 6e 75 | 6d 62 65 72 73 20 77 69 |small nu|mbers wi|
|000031d0| 74 68 6f 75 74 20 68 61 | 76 69 6e 67 20 74 6f 20 |thout ha|ving to |
|000031e0| 63 68 61 6e 67 65 20 74 | 68 65 20 0a 76 61 6c 75 |change t|he .valu|
|000031f0| 65 20 6f 66 20 28 31 65 | 2d 31 30 29 20 74 6f 20 |e of (1e|-10) to |
|00003200| 6d 61 74 63 68 20 74 68 | 65 20 28 61 76 65 72 61 |match th|e (avera|
|00003210| 67 65 29 20 73 69 7a 65 | 20 6f 66 20 74 68 65 20 |ge) size| of the |
|00003220| 74 77 6f 20 6e 75 6d 62 | 65 72 73 2e 0a 0a 0a 54 |two numb|ers....T|
|00003230| 68 65 20 43 75 73 74 6f | 6d 20 46 75 6e 63 74 69 |he Custo|m Functi|
|00003240| 6f 6e 0a 0a 49 20 68 61 | 76 65 20 77 72 69 74 74 |on..I ha|ve writt|
|00003250| 65 6e 20 61 20 73 69 6d | 70 6c 65 20 63 75 73 74 |en a sim|ple cust|
|00003260| 6f 6d 20 66 75 6e 63 74 | 69 6f 6e 20 63 61 6c 6c |om funct|ion call|
|00003270| 65 64 20 22 73 61 6d 65 | 5f 6e 75 6d 62 65 72 22 |ed "same|_number"|
|00003280| 20 77 68 69 63 68 20 79 | 6f 75 20 0a 77 69 6c 6c | which y|ou .will|
|00003290| 20 66 69 6e 64 20 69 6e | 20 74 68 65 20 66 69 6c | find in| the fil|
|000032a0| 65 20 5b 63 5f 53 61 6d | 65 5d 2e 20 20 54 68 69 |e [c_Sam|e]. Thi|
|000032b0| 73 20 63 75 73 74 6f 6d | 20 66 75 6e 63 74 69 6f |s custom| functio|
|000032c0| 6e 20 61 63 63 65 70 74 | 73 20 74 77 6f 20 0a 6e |n accept|s two .n|
|000032d0| 75 6d 62 65 72 73 20 61 | 73 20 69 74 73 20 70 61 |umbers a|s its pa|
|000032e0| 72 61 6d 65 74 65 72 73 | 20 61 6e 64 20 63 68 65 |rameters| and che|
|000032f0| 63 6b 73 20 77 68 65 74 | 68 65 72 20 74 68 65 79 |cks whet|her they|
|00003300| 20 61 72 65 20 74 68 65 | 20 73 61 6d 65 20 74 6f | are the| same to|
|00003310| 20 61 62 6f 75 74 20 0a | 6f 6e 65 20 70 61 72 74 | about .|one part|
|00003320| 20 69 6e 20 31 30 30 30 | 30 30 30 30 30 30 30 30 | in 1000|00000000|
|00003330| 30 30 30 30 20 28 6f 6e | 65 20 70 61 72 74 20 69 |0000 (on|e part i|
|00003340| 6e 20 61 20 74 68 6f 75 | 73 61 6e 64 20 6d 69 6c |n a thou|sand mil|
|00003350| 6c 69 6f 6e 20 6d 69 6c | 6c 69 6f 6e 29 2e 20 20 |lion mil|lion). |
|00003360| 0a 41 73 20 61 6e 20 65 | 78 61 6d 70 6c 65 20 6f |.As an e|xample o|
|00003370| 66 20 74 68 65 20 77 61 | 79 20 69 6e 20 77 68 69 |f the wa|y in whi|
|00003380| 63 68 20 74 68 69 73 20 | 63 75 73 74 6f 6d 20 66 |ch this |custom f|
|00003390| 75 6e 63 74 69 6f 6e 20 | 6d 61 79 20 62 65 20 75 |unction |may be u|
|000033a0| 73 65 64 20 68 61 76 65 | 20 0a 61 20 6c 6f 6f 6b |sed have| .a look|
|000033b0| 20 61 74 20 73 6c 6f 74 | 20 5b 45 72 72 6f 72 43 | at slot| [ErrorC|
|000033c0| 68 65 63 6b 5d 4a 31 30 | 20 61 6e 64 20 79 6f 75 |heck]J10| and you|
|000033d0| 20 77 69 6c 6c 20 73 65 | 65 20 74 68 61 74 20 69 | will se|e that i|
|000033e0| 74 20 72 65 74 75 72 6e | 73 20 74 68 65 20 0a 76 |t return|s the .v|
|000033f0| 61 6c 75 65 20 22 4f 4b | 22 2e 0a 0a 49 20 68 61 |alue "OK|"...I ha|
|00003400| 76 65 6e 27 74 20 74 72 | 69 65 64 20 74 68 69 73 |ven't tr|ied this|
|00003410| 20 63 75 73 74 6f 6d 20 | 66 75 6e 63 74 69 6f 6e | custom |function|
|00003420| 20 6f 75 74 20 66 6f 72 | 20 65 6e 6f 75 67 68 20 | out for| enough |
|00003430| 65 78 61 6d 70 6c 65 73 | 20 74 6f 20 62 65 20 73 |examples| to be s|
|00003440| 75 72 65 20 0a 69 74 20 | 69 73 20 74 68 65 20 62 |ure .it |is the b|
|00003450| 65 73 74 20 63 6f 6d 70 | 72 6f 6d 69 73 65 20 62 |est comp|romise b|
|00003460| 65 74 77 65 65 6e 20 61 | 63 63 75 72 61 63 79 20 |etween a|ccuracy |
|00003470| 61 6e 64 20 63 6f 6d 6d | 6f 6e 20 73 65 6e 73 65 |and comm|on sense|
|00003480| 20 62 75 74 20 79 6f 75 | 27 6c 6c 20 0a 66 69 6e | but you|'ll .fin|
|00003490| 64 20 74 68 61 74 20 69 | 66 20 79 6f 75 20 63 68 |d that i|f you ch|
|000034a0| 61 6e 67 65 20 74 68 65 | 20 28 31 65 2d 31 36 29 |ange the| (1e-16)|
|000034b0| 20 69 6e 20 73 6c 6f 74 | 20 5b 63 5f 53 61 6d 65 | in slot| [c_Same|
|000034c0| 5d 41 31 31 20 74 6f 20 | 28 31 65 2d 31 37 29 20 |]A11 to |(1e-17) |
|000034d0| 74 68 65 6e 20 0a 74 68 | 69 73 20 63 75 73 74 6f |then .th|is custo|
|000034e0| 6d 20 66 75 6e 63 74 69 | 6f 6e 20 72 65 74 75 72 |m functi|on retur|
|000034f0| 6e 73 20 22 45 72 72 6f | 72 22 20 69 6e 20 5b 45 |ns "Erro|r" in [E|
|00003500| 72 72 6f 72 43 68 65 63 | 6b 5d 4a 31 30 20 73 68 |rrorChec|k]J10 sh|
|00003510| 6f 77 69 6e 67 20 74 68 | 61 74 20 0a 6d 79 20 65 |owing th|at .my e|
|00003520| 72 72 6f 72 20 66 75 6e | 63 74 69 6f 6e 20 64 6f |rror fun|ction do|
|00003530| 65 73 20 68 61 76 65 20 | 61 20 76 61 6c 75 65 20 |es have |a value |
|00003540| 67 72 65 61 74 65 72 20 | 74 68 61 6e 20 30 2e 30 |greater |than 0.0|
|00003550| 30 30 30 30 30 30 30 30 | 30 30 30 30 30 30 30 31 |00000000|00000001|
|00003560| 21 0a 0a 54 68 65 20 27 | 65 78 70 65 72 69 6d 65 |!..The '|experime|
|00003570| 6e 74 27 20 6f 66 20 74 | 68 65 20 70 72 65 76 69 |nt' of t|he previ|
|00003580| 6f 75 73 20 70 61 72 61 | 67 72 61 70 68 20 73 68 |ous para|graph sh|
|00003590| 6f 77 73 20 74 68 61 74 | 20 74 68 65 20 76 61 6c |ows that| the val|
|000035a0| 75 65 20 6f 66 20 0a 28 | 31 65 2d 31 36 29 20 69 |ue of .(|1e-16) i|
|000035b0| 73 20 72 69 67 68 74 20 | 6f 6e 20 74 68 65 20 6c |s right |on the l|
|000035c0| 69 6d 69 74 20 6f 66 20 | 70 72 6f 64 75 63 69 6e |imit of |producin|
|000035d0| 67 20 66 61 6c 73 65 20 | 65 72 72 6f 72 20 6d 65 |g false |error me|
|000035e0| 73 73 61 67 65 73 20 77 | 69 74 68 20 0a 74 68 69 |ssages w|ith .thi|
|000035f0| 73 20 65 78 61 6d 70 6c | 65 2e 20 20 49 20 74 68 |s exampl|e. I th|
|00003600| 69 6e 6b 20 49 27 64 20 | 62 65 20 68 61 70 70 69 |ink I'd |be happi|
|00003610| 65 72 20 77 69 74 68 20 | 28 31 65 2d 31 34 29 20 |er with |(1e-14) |
|00003620| 6f 72 20 28 31 65 2d 31 | 30 29 20 66 6f 72 20 0a |or (1e-1|0) for .|
|00003630| 67 65 6e 65 72 61 6c 20 | 75 73 65 20 2d 20 62 75 |general |use - bu|
|00003640| 74 20 49 27 64 20 6c 69 | 6b 65 20 74 6f 20 6b 6e |t I'd li|ke to kn|
|00003650| 6f 77 20 77 68 61 74 20 | 79 6f 75 72 20 65 78 70 |ow what |your exp|
|00003660| 65 72 69 65 6e 63 65 20 | 69 73 20 6f 66 20 75 73 |erience |is of us|
|00003670| 69 6e 67 20 0a 73 75 63 | 68 20 61 20 66 75 6e 63 |ing .suc|h a func|
|00003680| 74 69 6f 6e 2e 20 20 46 | 61 6c 73 65 20 65 72 72 |tion. F|alse err|
|00003690| 6f 72 20 6d 65 73 73 61 | 67 65 73 20 66 72 6f 6d |or messa|ges from|
|000036a0| 20 61 20 6b 6e 6f 77 6e | 20 63 61 75 73 65 20 69 | a known| cause i|
|000036b0| 73 20 27 73 61 66 65 72 | 27 20 0a 74 68 61 6e 20 |s 'safer|' .than |
|000036c0| 66 61 6c 73 65 20 22 4f | 4b 22 20 6d 65 73 73 61 |false "O|K" messa|
|000036d0| 67 65 73 20 28 6f 72 2c | 20 61 73 20 69 6e 20 46 |ges (or,| as in F|
|000036e0| 69 72 65 77 6f 72 6b 7a | 2c 20 6e 6f 20 6d 65 73 |ireworkz|, no mes|
|000036f0| 73 61 67 65 20 61 74 20 | 61 6c 6c 29 2e 20 20 0a |sage at |all). .|
|00003700| 41 73 20 49 20 73 61 69 | 64 2c 20 74 68 69 73 20 |As I sai|d, this |
|00003710| 69 73 20 61 20 63 61 73 | 65 20 66 6f 72 20 66 75 |is a cas|e for fu|
|00003720| 72 74 68 65 72 20 65 78 | 70 65 72 69 6d 65 6e 74 |rther ex|periment|
|00003730| 61 74 69 6f 6e 2e 20 20 | 49 66 20 79 6f 75 20 67 |ation. |If you g|
|00003740| 65 74 20 0a 66 61 6c 73 | 65 20 65 72 72 6f 72 20 |et .fals|e error |
|00003750| 6d 65 73 73 61 67 65 73 | 20 77 69 74 68 20 28 31 |messages| with (1|
|00003760| 65 2d 31 36 29 20 74 68 | 65 6e 20 74 72 79 20 61 |e-16) th|en try a|
|00003770| 20 73 6c 69 67 68 74 6c | 79 20 6c 61 72 67 65 72 | slightl|y larger|
|00003780| 20 76 61 6c 75 65 20 62 | 75 74 20 0a 6e 65 76 65 | value b|ut .neve|
|00003790| 72 20 6d 6f 72 65 20 74 | 68 61 6e 20 28 31 65 2d |r more t|han (1e-|
|000037a0| 31 30 29 20 61 6e 64 20 | 6c 65 74 20 6d 65 20 6b |10) and |let me k|
|000037b0| 6e 6f 77 20 77 68 61 74 | 20 79 6f 75 20 65 76 65 |now what| you eve|
|000037c0| 6e 74 75 61 6c 6c 79 20 | 66 69 6e 64 20 69 73 20 |ntually |find is |
|000037d0| 61 20 0a 72 65 61 73 6f | 6e 61 62 6c 65 20 76 61 |a .reaso|nable va|
|000037e0| 6c 75 65 2e 20 20 49 27 | 6c 6c 20 72 65 70 6f 72 |lue. I'|ll repor|
|000037f0| 74 20 62 61 63 6b 20 6f | 6e 20 61 20 66 75 74 75 |t back o|n a futu|
|00003800| 72 65 20 64 69 73 63 2e | 0a 0a 0a 46 69 6e 61 6c |re disc.|...Final|
|00003810| 6c 79 0a 0a 4d 79 20 67 | 65 6e 65 72 61 6c 20 61 |ly..My g|eneral a|
|00003820| 64 76 69 63 65 20 74 6f | 20 74 68 6f 73 65 20 6f |dvice to| those o|
|00003830| 66 20 79 6f 75 20 77 69 | 74 68 20 6c 61 72 67 65 |f you wi|th large|
|00003840| 20 73 70 72 65 61 64 73 | 68 65 65 74 73 20 28 6f | spreads|heets (o|
|00003850| 72 20 6d 61 6e 79 20 0a | 6c 69 6e 6b 65 64 20 73 |r many .|linked s|
|00003860| 70 72 65 61 64 73 68 65 | 65 74 73 29 20 61 6e 64 |preadshe|ets) and|
|00003870| 20 77 68 6f 20 68 61 76 | 65 20 62 6f 74 68 20 50 | who hav|e both P|
|00003880| 69 70 65 44 72 65 61 6d | 20 61 6e 64 20 46 69 72 |ipeDream| and Fir|
|00003890| 65 77 6f 72 6b 7a 20 69 | 73 20 74 6f 20 0a 73 74 |eworkz i|s to .st|
|000038a0| 69 63 6b 20 74 6f 20 75 | 73 69 6e 67 20 50 69 70 |ick to u|sing Pip|
|000038b0| 65 44 72 65 61 6d 20 75 | 6e 74 69 6c 20 77 65 20 |eDream u|ntil we |
|000038c0| 66 69 6e 64 20 6f 75 74 | 20 74 68 65 20 65 78 74 |find out| the ext|
|000038d0| 65 6e 74 20 74 6f 20 77 | 68 69 63 68 20 74 68 65 |ent to w|hich the|
|000038e0| 20 6e 65 78 74 20 0a 76 | 65 72 73 69 6f 6e 20 6f | next .v|ersion o|
|000038f0| 66 20 46 69 72 65 77 6f | 72 6b 7a 20 69 73 20 27 |f Firewo|rkz is '|
|00003900| 62 65 74 74 65 72 27 20 | 74 68 61 6e 20 74 68 65 |better' |than the|
|00003910| 20 63 75 72 72 65 6e 74 | 20 76 65 72 73 69 6f 6e | current| version|
|00003920| 2e 20 20 49 20 6b 65 65 | 70 20 0a 73 61 79 69 6e |. I kee|p .sayin|
|00003930| 67 20 74 68 61 74 20 50 | 69 70 65 44 72 65 61 6d |g that P|ipeDream|
|00003940| 20 69 73 20 61 20 27 6d | 61 74 75 72 65 27 20 70 | is a 'm|ature' p|
|00003950| 61 63 6b 61 67 65 20 77 | 69 74 68 20 66 65 77 20 |ackage w|ith few |
|00003960| 27 62 75 67 73 27 20 74 | 68 61 74 20 61 72 65 2c |'bugs' t|hat are,|
|00003970| 20 0a 69 6e 20 74 68 65 | 20 6d 61 69 6e 20 22 6f | .in the| main "o|
|00003980| 62 73 63 75 72 65 20 61 | 6e 64 20 6b 6e 6f 77 6e |bscure a|nd known|
|00003990| 22 2e 20 20 57 68 61 74 | 20 49 20 6d 65 61 6e 20 |". What| I mean |
|000039a0| 69 73 20 74 68 61 74 20 | 49 20 61 6d 20 63 6f 6e |is that |I am con|
|000039b0| 66 69 64 65 6e 74 20 0a | 74 68 61 74 20 49 20 63 |fident .|that I c|
|000039c0| 61 6e 20 75 73 65 20 50 | 69 70 65 44 72 65 61 6d |an use P|ipeDream|
|000039d0| 20 74 6f 20 67 65 74 20 | 61 6e 73 77 65 72 73 20 | to get |answers |
|000039e0| 49 20 63 61 6e 20 62 65 | 6c 69 65 76 65 20 69 6e |I can be|lieve in|
|000039f0| 20 77 68 65 72 65 61 73 | 20 49 27 76 65 20 0a 68 | whereas| I've .h|
|00003a00| 61 64 20 61 20 66 65 77 | 20 6e 65 61 72 20 64 69 |ad a few| near di|
|00003a10| 73 61 73 74 65 72 73 20 | 77 69 74 68 20 6d 79 20 |sasters |with my |
|00003a20| 61 63 63 6f 75 6e 74 73 | 20 75 73 69 6e 67 20 46 |accounts| using F|
|00003a30| 69 72 65 77 6f 72 6b 7a | 2e 0a 0a 54 68 65 20 70 |ireworkz|...The p|
|00003a40| 72 6f 62 6c 65 6d 20 77 | 69 74 68 20 74 68 65 20 |roblem w|ith the |
|00003a50| 27 65 78 61 63 74 27 20 | 63 72 6f 73 73 20 63 68 |'exact' |cross ch|
|00003a60| 65 63 6b 20 6f 66 20 5b | 45 72 72 6f 72 43 68 65 |eck of [|ErrorChe|
|00003a70| 63 6b 5d 48 31 30 20 69 | 73 20 6e 6f 74 20 6f 6e |ck]H10 i|s not on|
|00003a80| 65 20 0a 6f 66 20 50 69 | 70 65 44 72 65 61 6d 27 |e .of Pi|peDream'|
|00003a90| 73 20 6d 61 6b 69 6e 67 | 3b 20 69 74 20 69 73 20 |s making|; it is |
|00003aa0| 69 6e 68 65 72 65 6e 74 | 20 69 6e 20 74 68 65 20 |inherent| in the |
|00003ab0| 6e 61 74 75 72 65 20 6f | 66 20 62 69 6e 61 72 79 |nature o|f binary|
|00003ac0| 20 0a 61 72 69 74 68 6d | 65 74 69 63 2e 20 20 54 | .arithm|etic. T|
|00003ad0| 68 65 20 27 77 6f 72 6b | 20 61 72 6f 75 6e 64 27 |he 'work| around'|
|00003ae0| 20 6f 66 20 73 65 65 69 | 6e 67 20 69 66 20 74 77 | of seei|ng if tw|
|00003af0| 6f 20 6e 75 6d 62 65 72 | 73 20 61 72 65 20 27 6e |o number|s are 'n|
|00003b00| 65 61 72 20 0a 65 6e 6f | 75 67 68 27 20 74 68 65 |ear .eno|ugh' the|
|00003b10| 20 73 61 6d 65 20 63 61 | 6e 20 62 65 20 69 6d 70 | same ca|n be imp|
|00003b20| 6c 65 6d 65 6e 74 65 64 | 20 62 79 20 6d 65 61 6e |lemented| by mean|
|00003b30| 73 20 6f 66 20 61 20 63 | 75 73 74 6f 6d 20 66 75 |s of a c|ustom fu|
|00003b40| 6e 63 74 69 6f 6e 2e 20 | 20 49 66 20 0a 79 6f 75 |nction. | If .you|
|00003b50| 20 68 61 76 65 20 61 20 | 6c 6f 74 20 6f 66 20 73 | have a |lot of s|
|00003b60| 75 63 68 20 63 72 6f 73 | 73 20 63 68 65 63 6b 73 |uch cros|s checks|
|00003b70| 20 69 6e 20 79 6f 75 72 | 20 73 70 72 65 61 64 73 | in your| spreads|
|00003b80| 68 65 65 74 20 74 68 65 | 6e 20 79 6f 75 27 6c 6c |heet the|n you'll|
|00003b90| 20 0a 66 69 6e 64 20 74 | 68 61 74 20 75 73 69 6e | .find t|hat usin|
|00003ba0| 67 20 74 68 65 20 63 75 | 73 74 6f 6d 20 66 75 6e |g the cu|stom fun|
|00003bb0| 63 74 69 6f 6e 20 67 69 | 76 65 73 20 79 6f 75 20 |ction gi|ves you |
|00003bc0| 74 68 65 20 75 73 75 61 | 6c 20 62 65 6e 65 66 69 |the usua|l benefi|
|00003bd0| 74 73 20 6f 66 20 0a 75 | 73 69 6e 67 20 63 75 73 |ts of .u|sing cus|
|00003be0| 74 6f 6d 20 66 75 6e 63 | 74 69 6f 6e 73 2e 20 20 |tom func|tions. |
|00003bf0| 54 68 65 20 62 65 6e 65 | 66 69 74 73 20 6f 66 20 |The bene|fits of |
|00003c00| 63 75 73 74 6f 6d 20 66 | 75 6e 63 74 69 6f 6e 73 |custom f|unctions|
|00003c10| 20 72 61 6e 67 65 20 66 | 72 6f 6d 20 0a 73 6d 61 | range f|rom .sma|
|00003c20| 6c 6c 65 72 20 73 70 72 | 65 61 64 73 68 65 65 74 |ller spr|eadsheet|
|00003c30| 73 20 28 77 68 69 63 68 | 20 6c 6f 61 64 20 61 6e |s (which| load an|
|00003c40| 64 20 73 61 76 65 20 6d | 6f 72 65 20 71 75 69 63 |d save m|ore quic|
|00003c50| 6b 6c 79 29 20 74 6f 20 | 63 6f 6e 73 69 73 74 65 |kly) to |consiste|
|00003c60| 6e 63 79 20 0a 61 6e 64 | 20 72 65 61 64 61 62 69 |ncy .and| readabi|
|00003c70| 6c 69 74 79 20 28 63 6f | 6e 73 69 73 74 65 6e 63 |lity (co|nsistenc|
|00003c80| 79 20 61 6e 64 20 72 65 | 61 64 61 62 69 6c 69 74 |y and re|adabilit|
|00003c90| 79 20 6d 61 6b 65 20 6d | 6f 64 69 66 69 63 61 74 |y make m|odificat|
|00003ca0| 69 6f 6e 73 20 74 6f 20 | 74 68 65 20 0a 73 68 65 |ions to |the .she|
|00003cb0| 65 74 20 65 61 73 69 65 | 72 2c 20 6d 6f 72 65 20 |et easie|r, more |
|00003cc0| 72 61 70 69 64 20 61 6e | 64 20 6d 6f 72 65 20 73 |rapid an|d more s|
|00003cd0| 75 72 65 29 2e 0a 0a 50 | 6c 65 61 73 65 20 6c 65 |ure)...P|lease le|
|00003ce0| 74 20 6d 65 20 6b 6e 6f | 77 20 69 66 20 79 6f 75 |t me kno|w if you|
|00003cf0| 20 66 65 65 6c 20 79 6f | 75 20 68 61 76 65 20 73 | feel yo|u have s|
|00003d00| 6f 6d 65 74 68 69 6e 67 | 20 74 6f 20 73 61 79 20 |omething| to say |
|00003d10| 6f 6e 20 74 68 69 73 20 | 0a 73 75 62 6a 65 63 74 |on this |.subject|
|00003d20| 20 61 6e 64 20 70 61 72 | 74 69 63 75 6c 61 72 6c | and par|ticularl|
|00003d30| 79 20 69 66 20 79 6f 75 | 20 64 65 76 65 6c 6f 70 |y if you| develop|
|00003d40| 20 74 68 65 20 63 75 73 | 74 6f 6d 20 66 75 6e 63 | the cus|tom func|
|00003d50| 74 69 6f 6e 20 66 75 72 | 74 68 65 72 2e 20 20 0a |tion fur|ther. .|
|00003d60| 44 65 66 69 6e 69 74 65 | 6c 79 20 6c 65 74 20 6d |Definite|ly let m|
|00003d70| 65 20 6b 6e 6f 77 20 68 | 6f 77 20 79 6f 75 20 77 |e know h|ow you w|
|00003d80| 6f 75 6c 64 20 6c 69 6b | 65 20 6d 65 20 74 6f 20 |ould lik|e me to |
|00003d90| 64 65 76 65 6c 6f 70 20 | 6d 79 20 61 72 74 69 63 |develop |my artic|
|00003da0| 6c 65 73 20 6f 6e 20 0a | 74 68 65 20 67 65 6e 65 |les on .|the gene|
|00003db0| 72 61 6c 20 73 75 62 6a | 65 63 74 20 6f 66 20 73 |ral subj|ect of s|
|00003dc0| 70 72 65 61 64 73 68 65 | 65 74 20 64 65 73 69 67 |preadshe|et desig|
|00003dd0| 6e 2e 0a 46 69 6c 65 44 | 61 74 61 82 41 74 74 65 |n..FileD|ata.Atte|
|00003de0| 6e 2f 73 70 72 00 fd 1c | 07 00 00 45 bc ff ff a8 |n/spr...|...E....|
|00003df0| f7 a7 81 03 00 76 51 53 | 50 52 45 41 44 53 48 45 |.....vQS|PREADSHE|
|00003e00| 45 54 00 00 00 00 00 00 | 00 00 00 00 00 14 00 02 |ET......|........|
|00003e10| 00 03 00 06 00 1a 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e20| 00 10 00 00 00 16 00 00 | 00 16 00 00 00 16 00 02 |........|........|
|00003e30| 00 05 00 04 00 03 e0 71 | 08 01 00 12 00 02 00 0f |.......q|........|
|00003e40| 17 0a 00 19 fc bf 00 80 | 17 0a 00 0a 12 0b 15 01 |........|........|
|00003e50| 00 21 00 01 00 1e 19 00 | 80 fb bf 19 04 80 fc bf |.!......|........|
|00003e60| 41 17 01 00 07 12 09 19 | 04 80 fc bf 41 17 01 00 |A.......|....A...|
|00003e70| 08 12 0a 15 01 00 1f 00 | 01 00 1c 19 ff bf fb bf |........|........|
|00003e80| 19 03 80 fc bf 17 01 00 | 08 12 09 17 02 00 0a 19 |........|........|
|00003e90| 03 80 fc bf 41 0a 15 01 | 00 25 00 01 00 22 19 00 |....A...|.%..."..|
|00003ea0| 80 fa bf 19 04 80 fb bf | 17 01 00 07 12 09 19 04 |........|........|
|00003eb0| 80 fb bf 17 01 00 08 12 | 0a 19 01 80 00 80 08 15 |........|........|
|00003ec0| 01 00 1f 00 01 00 1c 19 | ff bf fa bf 17 02 00 09 |........|........|
|00003ed0| 19 03 80 fb bf 41 09 19 | 03 80 fb bf 17 01 00 08 |.....A..|........|
|00003ee0| 12 0a 15 01 00 2e 00 01 | 00 2b 17 01 00 19 04 80 |........|.+......|
|00003ef0| fa bf 17 01 00 07 12 19 | 04 80 fa bf 17 01 00 08 |........|........|
|00003f00| 12 0a 19 00 80 fb bf 0a | 17 01 00 19 02 80 00 80 |........|........|
|00003f10| 0a 08 12 0a 15 01 00 2e | 00 01 00 2b 17 01 00 19 |........|...+....|
|00003f20| 03 80 fa bf 17 01 00 07 | 12 19 03 80 fa bf 17 01 |........|........|
|00003f30| 00 08 12 0a 19 ff bf fc | bf 0a 17 01 00 19 01 80 |........|........|
|00003f40| 00 80 0a 08 12 0a 15 01 | 00 25 00 01 00 22 19 fe |........|.%..."..|
|00003f50| bf fb bf 19 fe bf fc bf | 09 19 02 80 fa bf 0a 41 |........|.......A|
|00003f60| 19 02 80 fa bf 17 01 00 | 08 12 09 17 02 00 0a 15 |........|........|
|00003f70| 01 00 25 00 01 00 22 19 | 00 80 fa bf 19 04 80 f9 |..%...".|........|
|00003f80| bf 17 01 00 07 12 09 19 | 04 80 f9 bf 17 01 00 08 |........|........|
|00003f90| 12 0a 19 02 80 00 80 08 | 15 01 00 25 00 01 00 22 |........|...%..."|
|00003fa0| 19 ff bf fb bf 19 03 80 | f9 bf 17 01 00 07 12 09 |........|........|
|00003fb0| 19 03 80 f9 bf 17 01 00 | 08 12 0a 19 01 80 00 80 |........|........|
|00003fc0| 08 15 01 00 25 00 01 00 | 22 17 02 00 19 02 80 f9 |....%...|".......|
|00003fd0| bf 19 fe bf fa bf 09 19 | fe bf fb bf 09 41 09 19 |........|.....A..|
|00003fe0| 02 80 f9 bf 17 01 00 08 | 12 0a 15 04 00 02 00 09 |........|........|
|00003ff0| 00 03 00 02 00 00 0f 03 | 00 02 00 05 00 0d 00 ba |........|........|
|00004000| 00 47 72 61 70 68 31 00 | 00 00 00 00 00 00 00 00 |.Graph1.|........|
|00004010| 00 ff ff 00 00 ff ff 00 | 00 ff ff 00 00 ff ff 00 |........|........|
|00004020| 00 ff ff 00 00 ff ff 00 | 00 ff ff 00 00 ff ff 00 |........|........|
|00004030| 00 ff ff 00 00 ff ff 00 | 00 ff ff 00 00 ff ff 00 |........|........|
|00004040| 00 ff ff 00 00 ff ff 00 | 00 ff ff 00 00 ff ff 00 |........|........|
|00004050| 00 ff ff 00 00 ff ff 00 | 00 ff ff 00 00 ff ff 00 |........|........|
|00004060| 00 ff ff 00 00 ff ff 00 | 00 ff ff 00 00 ff ff 00 |........|........|
|00004070| 00 ff ff 00 00 ff ff 00 | 00 03 03 03 03 03 03 00 |........|........|
|00004080| 00 00 00 00 00 00 71 00 | 00 00 00 00 00 00 00 00 |......q.|........|
|00004090| 00 00 00 00 00 00 00 00 | 71 00 00 00 00 00 00 00 |........|q.......|
|000040a0| 00 00 00 00 00 00 00 00 | 00 04 00 00 00 00 14 01 |........|........|
|000040b0| 00 00 00 00 00 00 00 00 | 00 00 00 0e 00 02 00 00 |........|........|
|000040c0| 00 10 00 3a 00 82 2e c6 | 41 08 07 08 07 72 20 b6 |...:....|A....r .|
|000040d0| 33 d0 02 d0 02 00 00 00 | 00 01 00 ff ff 00 00 00 |3.......|........|
|000040e0| 00 f0 00 00 00 00 00 00 | 00 f0 00 02 00 00 00 00 |........|........|
|000040f0| 00 00 00 00 00 00 00 f0 | 00 00 00 00 00 00 00 11 |........|........|
|00004100| 00 0d 00 00 52 4f 4d 3a | 3a 42 4a 2e 57 44 52 00 |....ROM:|:BJ.WDR.|
|00004110| 12 00 03 00 25 46 00 13 | 00 03 00 25 50 00 08 00 |....%F..|...%P...|
|00004120| 08 00 ff ff 00 00 ff ff | 00 00 0f 00 18 00 00 00 |........|........|
|00004130| 00 00 c8 00 00 00 02 00 | c8 00 00 00 04 00 c8 00 |........|........|
|00004140| 00 00 06 00 c8 00 02 00 | 1e 00 00 00 00 00 0a ff |........|........|
|00004150| 16 41 54 54 45 4e 55 41 | 54 4f 52 20 44 45 53 49 |.ATTENUA|TOR DESI|
|00004160| 47 4e 20 44 41 54 41 00 | 02 00 39 00 00 00 02 00 |GN DATA.|..9.....|
|00004170| 0a ff 31 44 65 73 69 67 | 6e 20 64 61 74 61 20 66 |..1Desig|n data f|
|00004180| 6f 72 20 73 79 6d 6d 65 | 74 72 69 63 61 6c 20 50 |or symme|trical P|
|00004190| 69 20 6f 72 20 54 20 61 | 74 74 65 6e 75 61 74 6f |i or T a|ttenuato|
|000041a0| 72 73 3a 2d 00 02 00 11 | 00 00 00 04 00 0a ff 09 |rs:-....|........|
|000041b0| 49 6d 70 65 64 61 6e 63 | 65 00 02 00 09 00 01 00 |Impedanc|e.......|
|000041c0| 04 00 0b ff 32 00 00 02 | 00 0c 00 02 00 04 00 0a |....2...|........|
|000041d0| ff 04 4f 68 6d 73 00 02 | 00 13 00 00 00 05 00 0a |..Ohms..|........|
|000041e0| ff 0b 41 74 74 65 6e 75 | 61 74 69 6f 6e 00 02 00 |..Attenu|ation...|
|000041f0| 09 00 01 00 05 00 0b ff | 0a 00 00 02 00 0a 00 02 |........|........|
|00004200| 00 05 00 0a ff 02 64 42 | 00 02 00 11 00 05 00 05 |......dB|........|
|00004210| 00 8d ff 00 00 00 00 00 | 00 00 00 24 40 00 02 00 |........|...$@...|
|00004220| 13 00 00 00 07 00 0a ff | 0b 52 65 73 69 73 74 6f |........|.Resisto|
|00004230| 72 73 3a 2d 00 02 00 0a | 00 01 00 07 00 12 ff 02 |rs:-....|........|
|00004240| 52 31 00 02 00 0a 00 02 | 00 07 00 12 ff 02 52 32 |R1......|......R2|
|00004250| 00 02 00 09 00 03 00 07 | 00 0a ff 01 aa 00 02 00 |........|........|
|00004260| 15 00 00 00 09 00 0a ff | 0d 50 69 2d 61 74 74 65 |........|.Pi-atte|
|00004270| 6e 75 61 74 6f 72 00 02 | 00 11 00 01 00 09 00 8d |nuator..|........|
|00004280| 82 01 00 28 7c 36 86 d7 | 0f 58 40 00 02 00 11 00 |...(|6..|.X@.....|
|00004290| 02 00 09 00 8d 82 02 00 | 36 88 61 09 ae c9 51 40 |........|6.a...Q@|
|000042a0| 00 02 00 0c 00 03 00 09 | 00 0a ff 04 4f 68 6d 73 |........|....Ohms|
|000042b0| 00 02 00 14 00 00 00 0a | 00 0a ff 0c 54 2d 61 74 |........|....T-at|
|000042c0| 74 65 6e 75 61 74 6f 72 | 00 02 00 11 00 01 00 0a |tenuator|........|
|000042d0| 00 8d 82 03 00 f0 f2 5e | 75 85 f9 39 40 00 02 00 |.......^|u..9@...|
|000042e0| 11 00 02 00 0a 00 8d 82 | 04 00 6c bf de 28 76 91 |........|..l..(v.|
|000042f0| 41 40 00 02 00 0c 00 03 | 00 0a 00 0a ff 04 4f 68 |A@......|......Oh|
|00004300| 6d 73 00 02 00 38 00 00 | 00 0d 00 0a ff 30 44 65 |ms...8..|.....0De|
|00004310| 73 69 67 6e 20 64 61 74 | 61 20 66 6f 72 20 75 6e |sign dat|a for un|
|00004320| 62 61 6c 61 6e 63 65 64 | 20 50 69 20 6f 72 20 54 |balanced| Pi or T|
|00004330| 20 61 74 74 65 6e 75 61 | 74 6f 72 73 3a 2d 00 02 | attenua|tors:-..|
|00004340| 00 13 00 00 00 0f 00 0a | ff 0b 41 74 74 65 6e 75 |........|..Attenu|
|00004350| 61 74 69 6f 6e 00 02 00 | 09 00 01 00 0f 00 0b ff |ation...|........|
|00004360| 0a 00 00 02 00 0a 00 02 | 00 0f 00 0a ff 02 64 42 |........|......dB|
|00004370| 00 02 00 11 00 05 00 0f | 00 8d ff 00 00 00 00 00 |........|........|
|00004380| 00 00 00 24 40 00 02 00 | 17 00 00 00 10 00 0a ff |...$@...|........|
|00004390| 0f 49 6e 70 75 74 20 69 | 6d 70 65 64 61 6e 63 65 |.Input i|mpedance|
|000043a0| 00 02 00 09 00 01 00 10 | 00 0b ff 32 00 00 02 00 |........|...2....|
|000043b0| 0c 00 02 00 10 00 0a ff | 04 4f 68 6d 73 00 02 00 |........|.Ohms...|
|000043c0| 18 00 00 00 11 00 0a ff | 10 4f 75 74 70 75 74 20 |........|.Output |
|000043d0| 69 6d 70 65 64 61 6e 63 | 65 00 02 00 09 00 01 00 |impedanc|e.......|
|000043e0| 11 00 0b ff 32 00 00 02 | 00 0c 00 02 00 11 00 0a |....2...|........|
|000043f0| ff 04 4f 68 6d 73 00 02 | 00 12 00 00 00 13 00 0a |..Ohms..|........|
|00004400| ff 0a 52 65 73 69 73 74 | 6f 72 73 3a 00 02 00 0a |..Resist|ors:....|
|00004410| 00 01 00 13 00 12 ff 02 | 52 31 00 02 00 0a 00 02 |........|R1......|
|00004420| 00 13 00 12 ff 02 52 32 | 00 02 00 0a 00 03 00 13 |......R2|........|
|00004430| 00 12 ff 02 52 33 00 02 | 00 09 00 04 00 13 00 0a |....R3..|........|
|00004440| ff 01 aa 00 02 00 15 00 | 00 00 15 00 0a ff 0d 50 |........|.......P|
|00004450| 69 2d 61 74 74 65 6e 75 | 61 74 6f 72 00 02 00 11 |i-attenu|ator....|
|00004460| 00 01 00 15 00 8d 82 05 | 00 27 7c 36 86 d7 0f 58 |........|.'|6...X|
|00004470| 40 00 02 00 11 00 02 00 | 15 00 8d 82 06 00 27 7c |@.......|......'||
|00004480| 36 86 d7 0f 58 40 00 02 | 00 11 00 03 00 15 00 8d |6...X@..|........|
|00004490| 82 07 00 36 88 61 09 ae | c9 51 40 00 02 00 0c 00 |...6.a..|.Q@.....|
|000044a0| 04 00 15 00 0a ff 04 4f | 68 6d 73 00 02 00 14 00 |.......O|hms.....|
|000044b0| 00 00 16 00 0a ff 0c 54 | 2d 61 74 74 65 6e 75 61 |.......T|-attenua|
|000044c0| 74 6f 72 00 02 00 11 00 | 01 00 16 00 8d 82 08 00 |tor.....|........|
|000044d0| f0 f2 5e 75 85 f9 39 40 | 00 02 00 11 00 02 00 16 |..^u..9@|........|
|000044e0| 00 8d 82 09 00 f0 f2 5e | 75 85 f9 39 40 00 02 00 |.......^|u..9@...|
|000044f0| 11 00 03 00 16 00 8d 82 | 0a 00 6c bf de 28 76 91 |........|..l..(v.|
|00004500| 41 40 00 02 00 0c 00 04 | 00 16 00 0a ff 04 4f 68 |A@......|......Oh|
|00004510| 6d 73 00 46 69 6c 65 44 | 61 74 61 82 41 74 74 65 |ms.FileD|ata.Atte|
|00004520| 6e 2f 77 6b 31 00 fd 7b | 0a 00 00 45 b0 fd ff 78 |n/wk1..{|...E...x|
|00004530| d9 a1 81 03 00 e1 9d 00 | 00 02 00 06 04 06 00 08 |........|........|
|00004540| 00 00 00 00 00 00 00 00 | 00 96 00 06 00 00 00 00 |........|........|
|00004550| 00 00 00 2f 00 01 00 01 | 02 00 01 00 ff 03 00 01 |.../....|........|
|00004560| 00 00 04 00 01 00 00 05 | 00 01 00 00 07 00 20 00 |........|...... .|
|00004570| 00 00 00 00 71 00 09 00 | 05 00 14 00 00 00 00 00 |....q...|........|
|00004580| 00 00 00 00 00 00 00 00 | 04 00 04 00 4c 00 00 00 |........|....L...|
|00004590| 08 00 03 00 00 00 0f 64 | 00 20 00 20 00 00 00 00 |.......d|. . ....|
|000045a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045b0| 00 00 00 00 00 00 00 00 | 00 00 00 31 00 01 00 00 |........|...1....|
|000045c0| 18 00 19 00 00 ff ff 00 | 00 ff ff 00 00 ff ff 00 |........|........|
|000045d0| 00 ff ff 00 00 ff ff 00 | 00 ff ff 00 00 19 00 19 |........|........|
|000045e0| 00 ff ff 00 00 ff ff 00 | 00 ff ff 00 00 ff ff 00 |........|........|
|000045f0| 00 ff ff 00 00 ff ff 00 | 00 00 1a 00 08 00 ff ff |........|........|
|00004600| 00 00 ff ff 00 00 30 00 | 01 00 00 1c 00 08 00 ff |......0.|........|
|00004610| ff 00 00 ff ff 00 00 1b | 00 08 00 ff ff 00 00 ff |........|........|
|00004620| ff 00 00 1d 00 09 00 ff | ff 00 00 ff ff 00 00 00 |........|........|
|00004630| 23 00 09 00 ff ff 00 00 | ff ff 00 00 00 67 00 19 |#.......|.....g..|
|00004640| 00 ff ff 00 00 ff ff 00 | 00 ff ff 00 00 ff ff 00 |........|........|
|00004650| 00 ff ff 00 00 ff ff 00 | 00 00 69 00 28 00 ff ff |........|..i.(...|
|00004660| 00 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 ff ff |........|........|
|00004670| 00 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 ff ff |........|........|
|00004680| 00 00 ff ff 00 00 20 00 | 10 00 ff ff 00 00 ff ff |...... .|........|
|00004690| 00 00 ff ff 00 00 ff ff | 00 00 66 00 10 00 ff ff |........|..f.....|
|000046a0| 00 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 24 00 |........|......$.|
|000046b0| 01 00 00 25 00 f2 00 00 | 00 00 00 00 00 00 00 00 |...%....|........|
|000046c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047a0| 00 00 00 00 00 00 00 00 | 00 26 00 f2 00 00 00 00 |........|.&......|
|000047b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 27 |........|.......'|
|000048a0| 00 28 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.(......|........|
|000048b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000048c0| 00 00 00 00 00 00 00 00 | 00 00 00 28 00 0a 00 08 |........|...(....|
|000048d0| 00 4c 00 40 00 02 00 02 | 00 29 00 01 00 27 2a 00 |.L.@....|.)...'*.|
|000048e0| 10 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 ff ff |........|........|
|000048f0| 00 00 2d 00 b7 01 ff ff | 00 00 ff ff 00 00 ff ff |..-.....|........|
|00004900| 00 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 ff ff |........|........|
|00004910| 00 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 ff ff |........|........|
|00004920| 00 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 ff ff |........|........|
|00004930| 00 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 ff ff |........|........|
|00004940| 00 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 ff ff |........|........|
|00004950| 00 00 ff ff 00 00 ff ff | 00 00 ff ff 00 00 04 00 |........|........|
|00004960| 00 03 03 03 03 03 03 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000049a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000049b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000049c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000049d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000049e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000049f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004aa0| 00 00 00 00 00 00 00 71 | 71 01 00 00 00 0f 00 1d |.......q|q.......|
|00004ab0| 00 ff 00 00 00 00 27 41 | 54 54 45 4e 55 41 54 4f |......'A|TTENUATO|
|00004ac0| 52 20 44 45 53 49 47 4e | 20 44 41 54 41 00 0f 00 |R DESIGN| DATA...|
|00004ad0| 38 00 ff 00 00 02 00 27 | 44 65 73 69 67 6e 20 64 |8......'|Design d|
|00004ae0| 61 74 61 20 66 6f 72 20 | 73 79 6d 6d 65 74 72 69 |ata for |symmetri|
|00004af0| 63 61 6c 20 50 69 20 6f | 72 20 54 20 61 74 74 65 |cal Pi o|r T atte|
|00004b00| 6e 75 61 74 6f 72 73 3a | 2d 00 0f 00 10 00 ff 00 |nuators:|-.......|
|00004b10| 00 04 00 27 49 6d 70 65 | 64 61 6e 63 65 00 0d 00 |...'Impe|dance...|
|00004b20| 07 00 ff 01 00 04 00 32 | 00 0f 00 0b 00 ff 02 00 |.......2|........|
|00004b30| 04 00 27 4f 68 6d 73 00 | 0f 00 12 00 ff 00 00 05 |..'Ohms.|........|
|00004b40| 00 27 41 74 74 65 6e 75 | 61 74 69 6f 6e 00 0d 00 |.'Attenu|ation...|
|00004b50| 07 00 ff 01 00 05 00 0a | 00 0f 00 09 00 ff 02 00 |........|........|
|00004b60| 05 00 27 64 42 00 10 00 | 1e 00 ff 05 00 05 00 00 |..'dB...|........|
|00004b70| 00 00 00 00 00 00 00 0f | 00 05 0a 00 01 fc bf 00 |........|........|
|00004b80| 80 05 0a 00 0c 04 0d 03 | 0f 00 12 00 ff 00 00 07 |........|........|
|00004b90| 00 27 52 65 73 69 73 74 | 6f 72 73 3a 2d 00 0f 00 |.'Resist|ors:-...|
|00004ba0| 09 00 ff 01 00 07 00 22 | 52 31 00 0f 00 09 00 ff |......."|R1......|
|00004bb0| 02 00 07 00 22 52 32 00 | 0f 00 08 00 ff 03 00 07 |...."R2.|........|
|00004bc0| 00 27 9a 00 0f 00 14 00 | ff 00 00 09 00 27 50 69 |.'......|.....'Pi|
|00004bd0| 2d 61 74 74 65 6e 75 61 | 74 6f 72 00 10 00 2d 00 |-attenua|tor...-.|
|00004be0| 82 01 00 09 00 00 00 00 | 00 00 00 00 00 1e 00 01 |........|........|
|00004bf0| 00 80 fb bf 01 04 80 fc | bf 23 05 01 00 09 04 0b |........|.#......|
|00004c00| 01 04 80 fc bf 23 05 01 | 00 0a 04 0c 03 10 00 2b |.....#..|.......+|
|00004c10| 00 82 02 00 09 00 00 00 | 00 00 00 00 00 00 1c 00 |........|........|
|00004c20| 01 ff bf fb bf 01 03 80 | fc bf 05 01 00 0a 04 0b |........|........|
|00004c30| 05 02 00 0c 01 03 80 fc | bf 23 0c 03 0f 00 0b 00 |........|.#......|
|00004c40| ff 03 00 09 00 27 4f 68 | 6d 73 00 0f 00 13 00 ff |.....'Oh|ms......|
|00004c50| 00 00 0a 00 27 54 2d 61 | 74 74 65 6e 75 61 74 6f |....'T-a|ttenuato|
|00004c60| 72 00 10 00 31 00 82 01 | 00 0a 00 00 00 00 00 00 |r...1...|........|
|00004c70| 00 00 00 22 00 01 00 80 | fa bf 01 04 80 fb bf 05 |..."....|........|
|00004c80| 01 00 09 04 0b 01 04 80 | fb bf 05 01 00 0a 04 0c |........|........|
|00004c90| 01 01 80 00 80 0a 03 10 | 00 2b 00 82 02 00 0a 00 |........|.+......|
|00004ca0| 00 00 00 00 00 00 00 00 | 1c 00 01 ff bf fa bf 05 |........|........|
|00004cb0| 02 00 0b 01 03 80 fb bf | 23 0b 01 03 80 fb bf 05 |........|#.......|
|00004cc0| 01 00 0a 04 0c 03 0f 00 | 0b 00 ff 03 00 0a 00 27 |........|.......'|
|00004cd0| 4f 68 6d 73 00 0f 00 37 | 00 ff 00 00 0d 00 27 44 |Ohms...7|......'D|
|00004ce0| 65 73 69 67 6e 20 64 61 | 74 61 20 66 6f 72 20 75 |esign da|ta for u|
|00004cf0| 6e 62 61 6c 61 6e 63 65 | 64 20 50 69 20 6f 72 20 |nbalance|d Pi or |
|00004d00| 54 20 61 74 74 65 6e 75 | 61 74 6f 72 73 3a 2d 00 |T attenu|ators:-.|
|00004d10| 0f 00 12 00 ff 00 00 0f | 00 27 41 74 74 65 6e 75 |........|.'Attenu|
|00004d20| 61 74 69 6f 6e 00 0d 00 | 07 00 ff 01 00 0f 00 0a |ation...|........|
|00004d30| 00 0f 00 09 00 ff 02 00 | 0f 00 27 64 42 00 10 00 |........|..'dB...|
|00004d40| 1e 00 ff 05 00 0f 00 00 | 00 00 00 00 00 00 00 0f |........|........|
|00004d50| 00 05 0a 00 01 fc bf 00 | 80 05 0a 00 0c 04 0d 03 |........|........|
|00004d60| 0f 00 16 00 ff 00 00 10 | 00 27 49 6e 70 75 74 20 |........|.'Input |
|00004d70| 69 6d 70 65 64 61 6e 63 | 65 00 0d 00 07 00 ff 01 |impedanc|e.......|
|00004d80| 00 10 00 32 00 0f 00 0b | 00 ff 02 00 10 00 27 4f |...2....|......'O|
|00004d90| 68 6d 73 00 0f 00 17 00 | ff 00 00 11 00 27 4f 75 |hms.....|.....'Ou|
|00004da0| 74 70 75 74 20 69 6d 70 | 65 64 61 6e 63 65 00 0d |tput imp|edance..|
|00004db0| 00 07 00 ff 01 00 11 00 | 32 00 0f 00 0b 00 ff 02 |........|2.......|
|00004dc0| 00 11 00 27 4f 68 6d 73 | 00 0f 00 11 00 ff 00 00 |...'Ohms|........|
|00004dd0| 13 00 27 52 65 73 69 73 | 74 6f 72 73 3a 00 0f 00 |..'Resis|tors:...|
|00004de0| 09 00 ff 01 00 13 00 22 | 52 31 00 0f 00 09 00 ff |......."|R1......|
|00004df0| 02 00 13 00 22 52 32 00 | 0f 00 09 00 ff 03 00 13 |...."R2.|........|
|00004e00| 00 22 52 33 00 0f 00 08 | 00 ff 04 00 13 00 27 9a |."R3....|......'.|
|00004e10| 00 0f 00 14 00 ff 00 00 | 15 00 27 50 69 2d 61 74 |........|..'Pi-at|
|00004e20| 74 65 6e 75 61 74 6f 72 | 00 10 00 3a 00 82 01 00 |tenuator|...:....|
|00004e30| 15 00 00 00 00 00 00 00 | 00 00 2b 00 05 01 00 01 |........|..+.....|
|00004e40| 04 80 fa bf 05 01 00 09 | 04 01 04 80 fa bf 05 01 |........|........|
|00004e50| 00 0a 04 0c 01 00 80 fb | bf 0c 05 01 00 01 02 80 |........|........|
|00004e60| 00 80 0c 0a 04 0c 03 10 | 00 3a 00 82 02 00 15 00 |........|.:......|
|00004e70| 00 00 00 00 00 00 00 00 | 2b 00 05 01 00 01 03 80 |........|+.......|
|00004e80| fa bf 05 01 00 09 04 01 | 03 80 fa bf 05 01 00 0a |........|........|
|00004e90| 04 0c 01 ff bf fc bf 0c | 05 01 00 01 01 80 00 80 |........|........|
|00004ea0| 0c 0a 04 0c 03 10 00 31 | 00 82 03 00 15 00 00 00 |.......1|........|
|00004eb0| 00 00 00 00 00 00 22 00 | 01 fe bf fb bf 01 fe bf |......".|........|
|00004ec0| fc bf 0b 01 02 80 fa bf | 0c 23 01 02 80 fa bf 05 |........|.#......|
|00004ed0| 01 00 0a 04 0b 05 02 00 | 0c 03 0f 00 0b 00 ff 04 |........|........|
|00004ee0| 00 15 00 27 4f 68 6d 73 | 00 0f 00 13 00 ff 00 00 |...'Ohms|........|
|00004ef0| 16 00 27 54 2d 61 74 74 | 65 6e 75 61 74 6f 72 00 |..'T-att|enuator.|
|00004f00| 10 00 31 00 82 01 00 16 | 00 00 00 00 00 00 00 00 |..1.....|........|
|00004f10| 00 22 00 01 00 80 fa bf | 01 04 80 f9 bf 05 01 00 |."......|........|
|00004f20| 09 04 0b 01 04 80 f9 bf | 05 01 00 0a 04 0c 01 02 |........|........|
|00004f30| 80 00 80 0a 03 10 00 31 | 00 82 02 00 16 00 00 00 |.......1|........|
|00004f40| 00 00 00 00 00 00 22 00 | 01 ff bf fb bf 01 03 80 |......".|........|
|00004f50| f9 bf 05 01 00 09 04 0b | 01 03 80 f9 bf 05 01 00 |........|........|
|00004f60| 0a 04 0c 01 01 80 00 80 | 0a 03 10 00 31 00 82 03 |........|....1...|
|00004f70| 00 16 00 00 00 00 00 00 | 00 00 00 22 00 05 02 00 |........|..."....|
|00004f80| 01 02 80 f9 bf 01 fe bf | fa bf 0b 01 fe bf fb bf |........|........|
|00004f90| 0b 23 0b 01 02 80 f9 bf | 05 01 00 0a 04 0c 03 0f |.#......|........|
|00004fa0| 00 0b 00 ff 04 00 16 00 | 27 4f 68 6d 73 00 01 00 |........|'Ohms...|
|00004fb0| 00 00 46 69 6c 65 44 61 | 74 61 82 41 74 74 65 6e |..FileDa|ta.Atten|
|00004fc0| 75 61 74 6f 72 00 67 04 | 00 00 45 de fd ff e8 d4 |uator.g.|..E.....|
|00004fd0| a1 81 03 00 41 80 25 4f | 50 25 56 53 34 2e 31 33 |....A.%O|P%VS4.13|
|00004fe0| 20 28 32 38 2d 41 70 72 | 2d 39 32 29 2c 20 49 61 | (28-Apr|-92), Ia|
|00004ff0| 6e 20 57 69 6c 6c 69 61 | 6d 73 6f 6e 2c 20 52 34 |n Willia|mson, R4|
|00005000| 30 30 31 20 30 30 34 33 | 20 35 31 39 31 20 39 38 |001 0043| 5191 98|
|00005010| 35 34 20 0a 25 4f 50 25 | 54 4e 4e 0a 25 4f 50 25 |54 .%OP%|TNN.%OP%|
|00005020| 57 52 4e 0a 25 4f 50 25 | 44 50 46 0a 25 4f 50 25 |WRN.%OP%|DPF.%OP%|
|00005030| 49 52 59 0a 25 4f 50 25 | 50 4c 36 34 0a 25 4f 50 |IRY.%OP%|PL64.%OP|
|00005040| 25 54 4d 32 0a 25 4f 50 | 25 48 4d 30 0a 25 4f 50 |%TM2.%OP|%HM0.%OP|
|00005050| 25 42 4d 32 0a 25 4f 50 | 25 4c 4d 38 0a 25 4f 50 |%BM2.%OP|%LM8.%OP|
|00005060| 25 50 54 31 0a 25 4f 50 | 25 50 44 48 50 4a 65 74 |%PT1.%OP|%PDHPJet|
|00005070| 43 6f 75 72 0a 25 4f 50 | 25 57 43 32 2c 31 32 32 |Cour.%OP|%WC2,122|
|00005080| 34 2c 31 39 32 2c 39 38 | 30 2c 31 2c 31 36 2c 30 |4,192,98|0,1,16,0|
|00005090| 2c 30 0a 25 43 4f 3a 41 | 2c 31 35 2c 37 32 25 25 |,0.%CO:A|,15,72%%|
|000050a0| 48 31 25 25 48 32 25 41 | 54 54 45 4e 55 41 54 4f |H1%%H2%A|TTENUATO|
|000050b0| 52 20 44 45 53 49 47 4e | 20 44 41 54 41 0a 0a 44 |R DESIGN| DATA..D|
|000050c0| 65 73 69 67 6e 20 64 61 | 74 61 20 66 6f 72 20 25 |esign da|ta for %|
|000050d0| 48 32 25 73 79 6d 6d 65 | 74 72 69 63 61 6c 20 50 |H2%symme|trical P|
|000050e0| 69 20 6f 72 20 54 20 61 | 74 74 65 6e 75 61 74 6f |i or T a|ttenuato|
|000050f0| 72 73 3a 2d 0a 0a 49 6d | 70 65 64 61 6e 63 65 0a |rs:-..Im|pedance.|
|00005100| 41 74 74 65 6e 75 61 74 | 69 6f 6e 0a 0a 52 65 73 |Attenuat|ion..Res|
|00005110| 69 73 74 6f 72 73 3a 2d | 0a 0a 50 69 2d 61 74 74 |istors:-|..Pi-att|
|00005120| 65 6e 75 61 74 6f 72 0a | 54 2d 61 74 74 65 6e 75 |enuator.|T-attenu|
|00005130| 61 74 6f 72 0a 0a 0a 44 | 65 73 69 67 6e 20 64 61 |ator...D|esign da|
|00005140| 74 61 20 66 6f 72 20 25 | 48 32 25 75 6e 62 61 6c |ta for %|H2%unbal|
|00005150| 61 6e 63 65 64 20 50 69 | 20 6f 72 20 54 20 61 74 |anced Pi| or T at|
|00005160| 74 65 6e 75 61 74 6f 72 | 73 3a 2d 0a 0a 41 74 74 |tenuator|s:-..Att|
|00005170| 65 6e 75 61 74 69 6f 6e | 0a 49 6e 70 75 74 20 69 |enuation|.Input i|
|00005180| 6d 70 65 64 61 6e 63 65 | 0a 4f 75 74 70 75 74 20 |mpedance|.Output |
|00005190| 69 6d 70 65 64 61 6e 63 | 65 0a 0a 52 65 73 69 73 |impedanc|e..Resis|
|000051a0| 74 6f 72 73 3a 0a 0a 50 | 69 2d 61 74 74 65 6e 75 |tors:..P|i-attenu|
|000051b0| 61 74 6f 72 0a 54 2d 61 | 74 74 65 6e 75 61 74 6f |ator.T-a|ttenuato|
|000051c0| 72 0a 25 43 4f 3a 42 2c | 39 2c 35 33 25 0a 0a 0a |r.%CO:B,|9,53%...|
|000051d0| 0a 25 56 25 25 52 25 35 | 30 0a 25 56 25 25 52 25 |.%V%%R%5|0.%V%%R%|
|000051e0| 31 30 0a 0a 25 52 25 52 | 31 0a 0a 25 56 25 25 52 |10..%R%R|1..%V%%R|
|000051f0| 25 25 44 32 25 42 35 2a | 28 73 71 72 28 46 36 29 |%%D2%B5*|(sqr(F6)|
|00005200| 2b 31 29 2f 28 73 71 72 | 28 46 36 29 2d 31 29 0a |+1)/(sqr|(F6)-1).|
|00005210| 25 56 25 25 52 25 25 44 | 32 25 42 35 2a 28 46 36 |%V%%R%%D|2%B5*(F6|
|00005220| 2b 31 29 2f 28 46 36 2d | 31 29 2d 43 31 31 0a 0a |+1)/(F6-|1)-C11..|
|00005230| 0a 0a 0a 25 56 25 25 52 | 25 31 30 0a 25 56 25 25 |...%V%%R|%10.%V%%|
|00005240| 52 25 35 30 0a 25 56 25 | 25 52 25 35 30 0a 0a 25 |R%50.%V%|%R%50..%|
|00005250| 52 25 52 31 0a 0a 25 56 | 25 25 52 25 25 44 32 25 |R%R1..%V|%%R%%D2%|
|00005260| 31 2f 28 28 46 31 36 2b | 31 29 2f 28 46 31 36 2d |1/((F16+|1)/(F16-|
|00005270| 31 29 2f 42 31 37 2d 31 | 2f 44 32 32 29 0a 25 56 |1)/B17-1|/D22).%V|
|00005280| 25 25 52 25 25 44 32 25 | 42 31 37 2a 28 46 31 36 |%%R%%D2%|B17*(F16|
|00005290| 2b 31 29 2f 28 46 31 36 | 2d 31 29 2d 44 32 33 0a |+1)/(F16|-1)-D23.|
|000052a0| 25 43 4f 3a 43 2c 39 2c | 34 34 25 0a 0a 0a 0a 4f |%CO:C,9,|44%....O|
|000052b0| 68 6d 73 0a 64 42 0a 0a | 25 52 25 52 32 0a 0a 25 |hms.dB..|%R%R2..%|
|000052c0| 56 25 25 52 25 25 44 32 | 25 42 35 2a 28 46 36 2d |V%%R%%D2|%B5*(F6-|
|000052d0| 31 29 2f 32 2f 73 71 72 | 28 46 36 29 0a 25 56 25 |1)/2/sqr|(F6).%V%|
|000052e0| 25 52 25 25 44 32 25 42 | 35 2a 32 2a 73 71 72 28 |%R%%D2%B|5*2*sqr(|
|000052f0| 46 36 29 2f 28 46 36 2d | 31 29 0a 0a 0a 0a 0a 64 |F6)/(F6-|1).....d|
|00005300| 42 0a 4f 68 6d 73 0a 4f | 68 6d 73 0a 0a 25 52 25 |B.Ohms.O|hms..%R%|
|00005310| 52 32 0a 0a 25 56 25 25 | 52 25 25 44 32 25 31 2f |R2..%V%%|R%%D2%1/|
|00005320| 28 28 46 31 36 2b 31 29 | 2f 28 46 31 36 2d 31 29 |((F16+1)|/(F16-1)|
|00005330| 2f 42 31 38 2d 31 2f 44 | 32 32 29 0a 25 56 25 25 |/B18-1/D|22).%V%%|
|00005340| 52 25 25 44 32 25 42 31 | 38 2a 28 46 31 36 2b 31 |R%%D2%B1|8*(F16+1|
|00005350| 29 2f 28 46 31 36 2d 31 | 29 2d 44 32 33 0a 25 43 |)/(F16-1|)-D23.%C|
|00005360| 4f 3a 44 2c 39 2c 32 37 | 25 0a 0a 0a 0a 0a 0a 0a |O:D,9,27|%.......|
|00005370| a0 0a 0a 4f 68 6d 73 0a | 4f 68 6d 73 0a 0a 0a 0a |...Ohms.|Ohms....|
|00005380| 0a 0a 0a 0a 0a 25 52 25 | 52 33 0a 0a 25 56 25 25 |.....%R%|R3..%V%%|
|00005390| 52 25 25 44 32 25 73 71 | 72 28 42 31 37 2a 42 31 |R%%D2%sq|r(B17*B1|
|000053a0| 38 2f 46 31 36 29 2a 28 | 46 31 36 2d 31 29 2f 32 |8/F16)*(|F16-1)/2|
|000053b0| 0a 25 56 25 25 52 25 25 | 44 32 25 32 2a 73 71 72 |.%V%%R%%|D2%2*sqr|
|000053c0| 28 46 31 36 2a 42 31 37 | 2a 42 31 38 29 2f 28 46 |(F16*B17|*B18)/(F|
|000053d0| 31 36 2d 31 29 0a 25 43 | 4f 3a 45 2c 39 2c 37 32 |16-1).%C|O:E,9,72|
|000053e0| 25 0a 0a 0a 0a 0a 0a 0a | 0a 0a 0a 0a 0a 0a 0a 0a |%.......|........|
|000053f0| 0a 0a 0a 0a a0 0a 0a 4f | 68 6d 73 0a 4f 68 6d 73 |.......O|hms.Ohms|
|00005400| 0a 25 43 4f 3a 46 2c 30 | 2c 37 32 25 0a 0a 0a 0a |.%CO:F,0|,72%....|
|00005410| 0a 25 56 25 25 52 25 31 | 30 5e 28 42 36 2f 31 30 |.%V%%R%1|0^(B6/10|
|00005420| 29 0a 0a 0a 0a 0a 0a 0a | 0a 0a 0a 25 56 25 25 52 |).......|...%V%%R|
|00005430| 25 31 30 5e 28 42 31 36 | 2f 31 30 29 0a 46 69 6c |%10^(B16|/10).Fil|
|00005440| 65 44 61 74 61 82 50 44 | 3e 50 73 69 6f 6e 53 53 |eData.PD|>PsionSS|
|00005450| 00 10 20 00 00 45 de fd | ff ce 71 a7 81 03 00 1c |.. ..E..|..q.....|
|00005460| 9f 25 4f 50 25 56 53 34 | 2e 31 33 20 28 32 38 2d |.%OP%VS4|.13 (28-|
|00005470| 41 70 72 2d 39 32 29 2c | 20 49 61 6e 20 57 69 6c |Apr-92),| Ian Wil|
|00005480| 6c 69 61 6d 73 6f 6e 2c | 20 52 34 30 30 31 20 30 |liamson,| R4001 0|
|00005490| 30 34 33 20 35 31 39 31 | 20 39 38 35 34 20 0a 25 |043 5191| 9854 .%|
|000054a0| 4f 50 25 49 52 59 0a 25 | 4f 50 25 50 4c 36 34 0a |OP%IRY.%|OP%PL64.|
|000054b0| 25 4f 50 25 42 4d 32 0a | 25 4f 50 25 4c 4d 36 0a |%OP%BM2.|%OP%LM6.|
|000054c0| 25 4f 50 25 50 54 31 0a | 25 4f 50 25 50 44 43 6f |%OP%PT1.|%OP%PDCo|
|000054d0| 75 72 69 65 72 0a 25 4f | 50 25 57 43 32 2c 31 32 |urier.%O|P%WC2,12|
|000054e0| 33 36 2c 34 34 2c 39 38 | 30 2c 30 2c 34 2c 30 2c |36,44,98|0,0,4,0,|
|000054f0| 30 0a 25 43 4f 3a 41 2c | 31 30 2c 36 38 25 0a 25 |0.%CO:A,|10,68%.%|
|00005500| 43 25 54 72 61 6e 73 66 | 65 72 72 69 6e 67 20 50 |C%Transf|erring P|
|00005510| 69 70 65 44 72 65 61 6d | 20 66 69 6c 65 73 20 74 |ipeDream| files t|
|00005520| 6f 20 50 73 69 6f 6e 2f | 50 6f 63 6b 65 74 20 42 |o Psion/|Pocket B|
|00005530| 6f 6f 6b 20 53 70 72 65 | 61 64 73 68 65 65 74 20 |ook Spre|adsheet |
|00005540| 0a 25 43 25 49 61 6e 20 | 57 69 6c 6c 69 61 6d 73 |.%C%Ian |Williams|
|00005550| 6f 6e 0a 4b 65 79 77 6f | 72 64 73 3a 0a 54 72 61 |on.Keywo|rds:.Tra|
|00005560| 6e 73 66 65 72 20 50 69 | 70 65 44 72 65 61 6d 20 |nsfer Pi|peDream |
|00005570| 50 73 69 6f 6e 20 53 65 | 72 69 65 73 20 33 20 50 |Psion Se|ries 3 P|
|00005580| 6f 63 6b 65 74 42 6f 6f | 6b 20 73 70 72 65 61 64 |ocketBoo|k spread|
|00005590| 73 68 65 65 74 0a 0a 0a | 25 48 31 25 49 6e 74 72 |sheet...|%H1%Intr|
|000055a0| 6f 64 75 63 74 69 6f 6e | 0a 0a 41 73 20 6d 65 6e |oduction|..As men|
|000055b0| 74 69 6f 6e 65 64 20 69 | 6e 20 74 68 65 20 52 65 |tioned i|n the Re|
|000055c0| 61 64 4d 65 20 66 69 6c | 65 2c 20 74 68 65 73 65 |adMe fil|e, these|
|000055d0| 20 6e 6f 74 65 73 20 61 | 72 65 20 77 72 69 74 74 | notes a|re writt|
|000055e0| 65 6e 20 69 6e 20 0a 72 | 65 73 70 6f 6e 73 65 20 |en in .r|esponse |
|000055f0| 74 6f 20 61 20 63 61 6c | 6c 20 66 6f 72 20 68 65 |to a cal|l for he|
|00005600| 6c 70 20 66 72 6f 6d 20 | 53 74 65 76 65 20 48 75 |lp from |Steve Hu|
|00005610| 74 63 68 69 6e 73 6f 6e | 20 69 6e 20 74 68 65 20 |tchinson| in the |
|00005620| 46 65 62 72 75 61 72 79 | 20 0a 50 69 70 65 4c 69 |February| .PipeLi|
|00005630| 6e 65 2c 20 34 50 4c 39 | 34 30 32 2e 24 2e 48 65 |ne, 4PL9|402.$.He|
|00005640| 6c 70 2e 52 65 61 64 4d | 65 2e 20 20 48 65 20 73 |lp.ReadM|e. He s|
|00005650| 61 79 73 20 22 47 6f 69 | 6e 67 20 66 72 6f 6d 20 |ays "Goi|ng from |
|00005660| 50 69 70 65 44 72 65 61 | 6d 20 74 6f 20 0a 50 6f |PipeDrea|m to .Po|
|00005670| 63 6b 65 74 62 6f 6f 6b | 20 6c 65 61 64 73 20 74 |cketbook| leads t|
|00005680| 6f 20 63 6f 6e 74 69 6e | 75 61 6c 20 72 65 63 61 |o contin|ual reca|
|00005690| 6c 63 75 6c 61 74 69 6f | 6e 20 69 6e 20 74 68 65 |lculatio|n in the|
|000056a0| 20 70 6f 63 6b 65 74 62 | 6f 6f 6b 2e 2e 2e 22 20 | pocketb|ook..." |
|000056b0| 0a 0a 49 6e 69 74 69 61 | 6c 6c 79 20 49 20 68 61 |..Initia|lly I ha|
|000056c0| 64 20 74 68 65 20 73 61 | 6d 65 20 70 72 6f 62 6c |d the sa|me probl|
|000056d0| 65 6d 3b 20 74 68 65 20 | 66 69 72 73 74 20 74 69 |em; the |first ti|
|000056e0| 6d 65 20 49 20 73 75 66 | 66 65 72 65 64 20 66 72 |me I suf|fered fr|
|000056f0| 6f 6d 20 0a 63 6f 6e 74 | 69 6e 75 61 6c 20 72 65 |om .cont|inual re|
|00005700| 63 61 6c 63 75 6c 61 74 | 69 6f 6e 20 49 20 68 61 |calculat|ion I ha|
|00005710| 64 20 61 20 6d 69 6e 6f | 72 20 70 61 6e 69 63 2c |d a mino|r panic,|
|00005720| 20 49 20 74 68 6f 75 67 | 68 74 20 49 20 77 61 73 | I thoug|ht I was|
|00005730| 20 67 6f 69 6e 67 20 0a | 74 6f 20 68 61 76 65 20 | going .|to have |
|00005740| 74 6f 20 72 65 73 65 74 | 20 6d 79 20 50 73 69 6f |to reset| my Psio|
|00005750| 6e 20 61 6e 64 20 6c 6f | 73 65 20 61 6c 6c 20 6d |n and lo|se all m|
|00005760| 79 20 64 61 74 61 2e 20 | 20 46 6f 72 74 75 6e 61 |y data. | Fortuna|
|00005770| 74 65 6c 79 20 49 20 0a | 61 76 6f 69 64 65 64 20 |tely I .|avoided |
|00005780| 74 68 61 74 2c 20 61 6e | 64 20 68 61 76 69 6e 67 |that, an|d having|
|00005790| 20 63 61 72 65 66 75 6c | 6c 79 20 72 65 2d 72 65 | careful|ly re-re|
|000057a0| 61 64 20 74 68 65 20 50 | 73 69 6f 6e 20 53 70 72 |ad the P|sion Spr|
|000057b0| 65 61 64 73 68 65 65 74 | 20 0a 55 73 65 72 20 47 |eadsheet| .User G|
|000057c0| 75 69 64 65 20 49 20 72 | 65 61 6c 69 73 65 64 20 |uide I r|ealised |
|000057d0| 74 68 61 74 20 74 68 65 | 20 69 6e 66 6f 72 6d 61 |that the| informa|
|000057e0| 74 69 6f 6e 20 69 6e 20 | 74 68 65 20 55 73 65 72 |tion in |the User|
|000057f0| 20 47 75 69 64 65 20 69 | 73 20 0a 61 63 63 75 72 | Guide i|s .accur|
|00005800| 61 74 65 2c 20 69 66 20 | 74 6f 6f 20 62 72 69 65 |ate, if |too brie|
|00005810| 66 20 61 6e 64 20 64 69 | 66 66 69 63 75 6c 74 20 |f and di|fficult |
|00005820| 74 6f 20 66 6f 6c 6c 6f | 77 2e 0a 0a 54 68 65 20 |to follo|w...The |
|00005830| 6b 65 79 20 74 6f 20 73 | 75 63 63 65 73 73 66 75 |key to s|uccessfu|
|00005840| 6c 20 74 72 61 6e 73 66 | 65 72 20 69 73 20 25 48 |l transf|er is %H|
|00005850| 31 25 6e 6f 74 25 48 31 | 25 20 74 6f 20 75 73 65 |1%not%H1|% to use|
|00005860| 20 74 68 65 20 41 2d 4c | 69 6e 6b 20 63 6f 6e 76 | the A-L|ink conv|
|00005870| 65 72 73 69 6f 6e 20 0a | 77 69 6e 64 6f 77 2c 20 |ersion .|window, |
|00005880| 62 75 74 20 74 6f 20 64 | 72 61 67 20 61 20 4c 6f |but to d|rag a Lo|
|00005890| 74 75 73 20 31 32 33 20 | 66 6f 72 6d 61 74 20 73 |tus 123 |format s|
|000058a0| 70 72 65 61 64 73 68 65 | 65 74 20 66 69 6c 65 20 |preadshe|et file |
|000058b0| 66 72 6f 6d 20 61 20 0a | 64 69 72 65 63 74 6f 72 |from a .|director|
|000058c0| 79 20 6f 6e 20 41 52 4d | 20 69 6e 74 6f 20 74 68 |y on ARM| into th|
|000058d0| 65 20 69 6e 74 65 72 6e | 61 6c 20 64 69 73 63 20 |e intern|al disc |
|000058e0| 6f 6e 20 79 6f 75 72 20 | 50 73 69 6f 6e 2c 20 61 |on your |Psion, a|
|000058f0| 6e 64 20 74 68 65 6e 20 | 6c 65 74 20 0a 74 68 65 |nd then |let .the|
|00005900| 20 50 73 69 6f 6e 20 73 | 70 72 65 61 64 73 68 65 | Psion s|preadshe|
|00005910| 65 74 20 64 6f 20 74 68 | 65 20 63 6f 6e 76 65 72 |et do th|e conver|
|00005920| 73 69 6f 6e 2e 20 20 54 | 68 75 73 20 74 68 65 72 |sion. T|hus ther|
|00005930| 65 20 61 72 65 20 74 68 | 72 65 65 20 0a 62 61 73 |e are th|ree .bas|
|00005940| 69 63 20 73 74 65 70 73 | 20 69 6e 20 74 68 65 20 |ic steps| in the |
|00005950| 70 72 6f 63 65 73 73 3a | 0a 0a 31 29 2e 20 20 20 |process:|..1). |
|00005960| 20 20 43 6f 6e 76 65 72 | 74 20 66 72 6f 6d 20 50 | Conver|t from P|
|00005970| 69 70 65 44 72 65 61 6d | 20 74 6f 20 4c 6f 74 75 |ipeDream| to Lotu|
|00005980| 73 20 31 32 33 20 66 6f | 72 6d 61 74 0a 32 29 2e |s 123 fo|rmat.2).|
|00005990| 20 20 20 20 20 54 72 61 | 6e 73 66 65 72 20 66 69 | Tra|nsfer fi|
|000059a0| 6c 65 20 66 72 6f 6d 20 | 41 52 4d 20 74 6f 20 50 |le from |ARM to P|
|000059b0| 73 69 6f 6e 20 69 6e 74 | 65 72 6e 61 6c 20 64 69 |sion int|ernal di|
|000059c0| 73 63 0a 33 29 2e 20 20 | 20 20 20 43 6f 6e 76 65 |sc.3). | Conve|
|000059d0| 72 74 20 66 69 6c 65 20 | 74 6f 20 53 50 52 20 66 |rt file |to SPR f|
|000059e0| 6f 72 6d 61 74 0a 0a 54 | 68 69 73 20 6d 65 74 68 |ormat..T|his meth|
|000059f0| 6f 64 20 69 73 20 66 6f | 6f 6c 70 72 6f 6f 66 20 |od is fo|olproof |
|00005a00| 61 6e 64 20 61 76 6f 69 | 64 73 20 74 68 65 20 70 |and avoi|ds the p|
|00005a10| 72 6f 62 6c 65 6d 20 6f | 66 20 63 6f 6e 74 69 6e |roblem o|f contin|
|00005a20| 75 61 6c 20 0a 72 65 63 | 61 6c 63 75 6c 61 74 69 |ual .rec|alculati|
|00005a30| 6f 6e 2e 0a 0a 54 68 65 | 73 65 20 6e 6f 74 65 73 |on...The|se notes|
|00005a40| 20 77 65 72 65 20 77 72 | 69 74 74 65 6e 20 74 6f | were wr|itten to|
|00005a50| 20 65 78 70 6c 61 69 6e | 20 69 6e 20 67 72 65 61 | explain| in grea|
|00005a60| 74 65 72 20 64 65 74 61 | 69 6c 20 77 68 61 74 20 |ter deta|il what |
|00005a70| 69 73 20 67 6f 69 6e 67 | 20 0a 6f 6e 2c 20 61 6e |is going| .on, an|
|00005a80| 64 20 77 68 61 74 20 74 | 6f 20 64 6f 20 77 68 65 |d what t|o do whe|
|00005a90| 6e 20 74 72 61 6e 73 66 | 65 72 72 69 6e 67 20 61 |n transf|erring a|
|00005aa0| 20 73 70 72 65 61 64 73 | 68 65 65 74 20 66 69 6c | spreads|heet fil|
|00005ab0| 65 20 66 72 6f 6d 20 0a | 50 69 70 65 44 72 65 61 |e from .|PipeDrea|
|00005ac0| 6d 20 74 6f 20 50 73 69 | 6f 6e 2e 20 20 4f 6e 63 |m to Psi|on. Onc|
|00005ad0| 65 20 79 6f 75 20 61 72 | 65 20 63 6f 6e 66 69 64 |e you ar|e confid|
|00005ae0| 65 6e 74 20 79 6f 75 20 | 6d 61 79 20 70 72 65 66 |ent you |may pref|
|00005af0| 65 72 20 74 6f 20 75 73 | 65 20 0a 74 68 65 20 61 |er to us|e .the a|
|00005b00| 73 73 6f 63 69 61 74 65 | 64 20 62 72 69 65 66 20 |ssociate|d brief |
|00005b10| 6e 6f 74 65 73 2c 20 50 | 44 3e 50 73 53 53 2e 0a |notes, P|D>PsSS..|
|00005b20| 0a 0a 25 48 31 25 43 6f | 6e 76 65 72 73 69 6f 6e |..%H1%Co|nversion|
|00005b30| 20 66 72 6f 6d 20 50 69 | 70 65 44 72 65 61 6d 20 | from Pi|peDream |
|00005b40| 74 6f 20 4c 6f 74 75 73 | 20 66 6f 72 6d 61 74 0a |to Lotus| format.|
|00005b50| 0a 4f 6e 20 74 68 65 20 | 41 52 4d 3a 0a 0a 44 6f |.On the |ARM:..Do|
|00005b60| 75 62 6c 65 20 63 6c 69 | 63 6b 20 6f 6e 20 21 50 |uble cli|ck on !P|
|00005b70| 44 31 32 33 20 74 6f 20 | 6c 6f 61 64 20 43 6f 6c |D123 to |load Col|
|00005b80| 74 6f 6e 73 6f 66 74 27 | 73 20 50 69 70 65 44 72 |tonsoft'|s PipeDr|
|00005b90| 65 61 6d 20 74 6f 20 4c | 6f 74 75 73 20 0a 63 6f |eam to L|otus .co|
|00005ba0| 6e 76 65 72 74 6f 72 2e | 20 20 44 72 61 67 20 74 |nvertor.| Drag t|
|00005bb0| 68 65 20 50 44 20 66 69 | 6c 65 20 79 6f 75 20 77 |he PD fi|le you w|
|00005bc0| 69 73 68 20 74 6f 20 63 | 6f 6e 76 65 72 74 20 6f |ish to c|onvert o|
|00005bd0| 6e 74 6f 20 74 68 65 20 | 50 44 31 32 33 20 0a 69 |nto the |PD123 .i|
|00005be0| 63 6f 6e 2e 20 20 41 20 | 73 6d 61 6c 6c 20 53 61 |con. A |small Sa|
|00005bf0| 76 65 20 61 73 3a 20 77 | 69 6e 64 6f 77 20 77 69 |ve as: w|indow wi|
|00005c00| 6c 6c 20 6f 70 65 6e 20 | 77 69 74 68 20 74 68 65 |ll open |with the|
|00005c10| 20 72 65 64 20 31 32 33 | 20 69 63 6f 6e 20 61 6e | red 123| icon an|
|00005c20| 64 20 0a 74 68 65 20 6c | 65 61 66 6e 61 6d 65 20 |d .the l|eafname |
|00005c30| 4c 6f 74 75 73 46 69 6c | 65 20 69 6e 20 74 68 65 |LotusFil|e in the|
|00005c40| 20 64 69 61 6c 6f 67 75 | 65 20 62 6f 78 2e 20 20 | dialogu|e box. |
|00005c50| 43 68 61 6e 67 65 20 74 | 68 65 20 6e 61 6d 65 20 |Change t|he name |
|00005c60| 74 6f 20 0a 73 6f 6d 65 | 74 68 69 6e 67 20 6d 6f |to .some|thing mo|
|00005c70| 72 65 20 69 6e 66 6f 72 | 6d 61 74 69 76 65 20 28 |re infor|mative (|
|00005c80| 77 69 74 68 20 61 20 6d | 61 78 69 6d 75 6d 20 6f |with a m|aximum o|
|00005c90| 66 20 38 20 63 68 61 72 | 61 63 74 65 72 73 2c 20 |f 8 char|acters, |
|00005ca0| 61 6e 64 20 61 64 64 20 | 0a 2f 57 4b 31 20 77 68 |and add |./WK1 wh|
|00005cb0| 69 63 68 20 77 69 6c 6c | 20 62 65 20 72 65 63 6f |ich will| be reco|
|00005cc0| 67 6e 69 73 65 64 20 61 | 73 20 74 68 65 20 4c 6f |gnised a|s the Lo|
|00005cd0| 74 75 73 20 66 69 6c 65 | 20 69 64 65 6e 74 69 66 |tus file| identif|
|00005ce0| 69 65 72 29 2c 20 74 68 | 65 6e 20 0a 64 72 61 67 |ier), th|en .drag|
|00005cf0| 20 74 68 65 20 31 32 33 | 20 69 63 6f 6e 20 6f 6e | the 123| icon on|
|00005d00| 74 6f 20 61 20 73 75 69 | 74 61 62 6c 65 20 64 69 |to a sui|table di|
|00005d10| 72 65 63 74 6f 72 79 20 | 6f 6e 20 61 20 44 4f 53 |rectory |on a DOS|
|00005d20| 20 66 6f 72 6d 61 74 20 | 64 69 73 63 3a 20 0a 79 | format |disc: .y|
|00005d30| 6f 75 20 63 6f 75 6c 64 | 20 6f 66 20 63 6f 75 72 |ou could| of cour|
|00005d40| 73 65 20 72 65 6e 61 6d | 65 20 74 68 65 20 66 69 |se renam|e the fi|
|00005d50| 6c 65 20 61 66 74 65 72 | 20 73 61 76 69 6e 67 20 |le after| saving |
|00005d60| 69 74 2e 0a 0a 53 6f 6d | 65 74 69 6d 65 73 20 79 |it...Som|etimes y|
|00005d70| 6f 75 20 6d 61 79 20 73 | 65 65 20 0a 0a 45 72 72 |ou may s|ee ..Err|
|00005d80| 6f 72 20 66 72 6f 6d 20 | 50 69 70 65 44 72 65 61 |or from |PipeDrea|
|00005d90| 6d 3a 0a 45 78 70 72 65 | 73 73 69 6f 6e 20 6e 6f |m:.Expre|ssion no|
|00005da0| 74 20 63 6f 6d 70 6c 65 | 74 65 6c 79 20 63 6f 6e |t comple|tely con|
|00005db0| 76 65 72 74 65 64 2e 0a | 0a 54 68 69 73 20 69 73 |verted..|.This is|
|00005dc0| 20 62 65 63 61 75 73 65 | 20 74 68 65 72 65 20 61 | because| there a|
|00005dd0| 72 65 20 73 6f 6d 65 20 | 50 69 70 65 44 72 65 61 |re some |PipeDrea|
|00005de0| 6d 20 65 78 70 72 65 73 | 73 69 6f 6e 73 20 74 68 |m expres|sions th|
|00005df0| 61 74 20 68 61 76 65 20 | 6e 6f 20 0a 73 69 6d 70 |at have |no .simp|
|00005e00| 6c 65 20 64 69 72 65 63 | 74 20 65 71 75 69 76 61 |le direc|t equiva|
|00005e10| 6c 65 6e 74 20 69 6e 20 | 74 68 65 20 4c 6f 74 75 |lent in |the Lotu|
|00005e20| 73 20 66 6f 72 6d 61 74 | 2c 20 61 6e 64 20 79 6f |s format|, and yo|
|00005e30| 75 20 77 69 6c 6c 20 68 | 61 76 65 20 74 6f 20 0a |u will h|ave to .|
|00005e40| 72 65 77 72 69 74 65 20 | 74 68 6f 73 65 20 70 61 |rewrite |those pa|
|00005e50| 72 74 73 20 6f 66 20 74 | 68 65 20 73 70 72 65 61 |rts of t|he sprea|
|00005e60| 64 73 68 65 65 74 20 77 | 68 65 6e 20 79 6f 75 20 |dsheet w|hen you |
|00005e70| 68 61 76 65 20 6c 6f 61 | 64 65 64 20 69 74 20 69 |have loa|ded it i|
|00005e80| 6e 74 6f 20 0a 50 73 69 | 6f 6e 2e 20 20 43 6c 69 |nto .Psi|on. Cli|
|00005e90| 63 6b 20 6f 6e 20 4f 4b | 20 61 6e 64 20 74 68 65 |ck on OK| and the|
|00005ea0| 20 63 6f 6e 76 65 72 73 | 69 6f 6e 20 77 69 6c 6c | convers|ion will|
|00005eb0| 20 62 65 20 73 61 76 65 | 64 2e 20 0a 0a 0a 25 48 | be save|d. ...%H|
|00005ec0| 31 25 54 72 61 6e 73 66 | 65 72 20 66 69 6c 65 20 |1%Transf|er file |
|00005ed0| 66 72 6f 6d 20 41 52 4d | 20 74 6f 20 50 73 69 6f |from ARM| to Psio|
|00005ee0| 6e 0a 0a 4f 6e 20 74 68 | 65 20 50 73 69 6f 6e 3a |n..On th|e Psion:|
|00005ef0| 0a 0a 50 6c 75 67 20 69 | 6e 20 41 2d 4c 69 6e 6b |..Plug i|n A-Link|
|00005f00| 20 69 6e 74 6f 20 74 68 | 65 20 65 78 70 61 6e 73 | into th|e expans|
|00005f10| 69 6f 6e 20 73 6f 63 6b | 65 74 20 6f 6e 20 74 68 |ion sock|et on th|
|00005f20| 65 20 6c 65 66 74 2d 68 | 61 6e 64 20 73 69 64 65 |e left-h|and side|
|00005f30| 20 6f 66 20 0a 74 68 65 | 20 50 73 69 6f 6e 2e 20 | of .the| Psion. |
|00005f40| 20 49 74 20 77 6f 75 6c | 64 20 61 6c 73 6f 20 62 | It woul|d also b|
|00005f50| 65 20 61 64 76 69 73 61 | 62 6c 65 20 74 6f 20 75 |e advisa|ble to u|
|00005f60| 73 65 20 74 68 65 20 65 | 78 74 65 72 6e 61 6c 20 |se the e|xternal |
|00005f70| 0a 70 6f 77 65 72 20 73 | 75 70 70 6c 79 20 64 75 |.power s|upply du|
|00005f80| 72 69 6e 67 20 74 68 65 | 20 66 6f 6c 6c 6f 77 69 |ring the| followi|
|00005f90| 6e 67 20 66 69 6c 65 20 | 74 72 61 6e 73 66 65 72 |ng file |transfer|
|00005fa0| 2e 20 20 46 72 6f 6d 20 | 74 68 65 20 53 79 73 74 |. From |the Syst|
|00005fb0| 65 6d 20 0a 73 63 72 65 | 65 6e 20 70 72 65 73 73 |em .scre|en press|
|00005fc0| 20 3c 4d 65 6e 75 3e 20 | 61 6e 64 20 73 65 6c 65 | <Menu> |and sele|
|00005fd0| 63 74 20 53 70 65 63 69 | 61 6c 20 52 65 6d 6f 74 |ct Speci|al Remot|
|00005fe0| 65 20 6c 69 6e 6b 2c 20 | 6f 72 20 70 72 65 73 73 |e link, |or press|
|00005ff0| 20 0a 3c 50 73 69 6f 6e | 2d 4c 3e 2e 20 20 54 68 | .<Psion|-L>. Th|
|00006000| 65 20 52 65 6d 6f 74 65 | 20 6c 69 6e 6b 20 77 69 |e Remote| link wi|
|00006010| 6e 64 6f 77 20 77 69 6c | 6c 20 6f 70 65 6e 2e 20 |ndow wil|l open. |
|00006020| 20 53 65 74 3a 0a 0a 52 | 65 6d 6f 74 65 20 6c 69 | Set:..R|emote li|
|00006030| 6e 6b 20 20 0a 42 61 75 | 64 20 72 61 74 65 0a 0a |nk .Bau|d rate..|
|00006040| 50 72 65 73 73 20 3c 45 | 6e 74 65 72 3e 2e 0a 0a |Press <E|nter>...|
|00006050| 0a 4f 6e 20 74 68 65 20 | 41 52 4d 3a 0a 0a 44 6f |.On the |ARM:..Do|
|00006060| 75 62 6c 65 20 63 6c 69 | 63 6b 20 6f 6e 20 74 68 |uble cli|ck on th|
|00006070| 65 20 21 50 6f 63 6b 65 | 74 46 53 20 69 63 6f 6e |e !Pocke|tFS icon|
|00006080| 20 74 6f 20 6c 6f 61 64 | 20 74 68 65 20 70 72 6f | to load| the pro|
|00006090| 67 72 61 6d 2e 20 20 54 | 68 65 20 0a 50 6f 63 6b |gram. T|he .Pock|
|000060a0| 65 74 46 53 20 69 63 6f | 6e 20 77 69 6c 6c 20 61 |etFS ico|n will a|
|000060b0| 70 70 65 61 72 20 6f 6e | 20 74 68 65 20 69 63 6f |ppear on| the ico|
|000060c0| 6e 20 62 61 72 20 61 6e | 64 20 73 68 6f 75 6c 64 |n bar an|d should|
|000060d0| 20 6e 6f 74 20 62 65 20 | 0a 70 61 72 74 69 61 6c | not be |.partial|
|000060e0| 6c 79 20 66 69 6c 6c 65 | 64 20 77 69 74 68 20 72 |ly fille|d with r|
|000060f0| 65 64 3b 20 69 66 20 69 | 74 20 69 73 20 63 68 65 |ed; if i|t is che|
|00006100| 63 6b 20 61 67 61 69 6e | 20 74 68 61 74 20 52 65 |ck again| that Re|
|00006110| 6d 6f 74 65 20 6c 69 6e | 6b 20 69 73 20 0a 4f 6e |mote lin|k is .On|
|00006120| 2c 20 61 6e 64 20 74 68 | 61 74 20 61 6c 6c 20 73 |, and th|at all s|
|00006130| 65 72 69 61 6c 20 70 6f | 72 74 20 63 6f 6e 6e 65 |erial po|rt conne|
|00006140| 63 74 69 6f 6e 73 20 61 | 72 65 20 67 6f 6f 64 2e |ctions a|re good.|
|00006150| 0a 0a 43 6c 69 63 6b 20 | 3c 4d 65 6e 75 3e 20 6f |..Click |<Menu> o|
|00006160| 76 65 72 20 74 68 65 20 | 50 6f 63 6b 65 74 46 53 |ver the |PocketFS|
|00006170| 20 69 63 6f 6e 2c 20 61 | 6e 64 20 63 6c 69 63 6b | icon, a|nd click|
|00006180| 20 6f 6e 20 4f 70 65 6e | 20 27 24 27 2e 20 20 41 | on Open| '$'. A|
|00006190| 20 0a 66 69 6c 69 6e 67 | 20 77 69 6e 64 6f 77 20 | .filing| window |
|000061a0| 77 69 6c 6c 20 6f 70 65 | 6e 20 77 69 74 68 20 74 |will ope|n with t|
|000061b0| 68 65 20 6e 61 6d 65 20 | 50 6f 63 6b 65 74 46 53 |he name |PocketFS|
|000061c0| 3a 3a 52 65 6d 6f 74 65 | 2e 24 2e 20 69 6e 20 74 |::Remote|.$. in t|
|000061d0| 68 65 20 0a 74 69 74 6c | 65 20 62 61 72 2c 20 61 |he .titl|e bar, a|
|000061e0| 6e 64 20 61 74 20 6c 65 | 61 73 74 20 74 77 6f 20 |nd at le|ast two |
|000061f0| 64 69 72 65 63 74 6f 72 | 69 65 73 2c 20 43 20 26 |director|ies, C &|
|00006200| 20 4d 2c 20 69 66 20 79 | 6f 75 20 68 61 76 65 20 | M, if y|ou have |
|00006210| 0a 50 6f 63 6b 65 74 42 | 6f 6f 6b 20 6f 72 20 50 |.PocketB|ook or P|
|00006220| 73 69 6f 6e 20 53 65 72 | 69 65 73 20 33 61 2e 20 |sion Ser|ies 3a. |
|00006230| 20 49 66 20 6c 69 6b 65 | 20 6d 65 20 79 6f 75 20 | If like| me you |
|00006240| 68 61 76 65 20 50 73 69 | 6f 6e 20 53 65 72 69 65 |have Psi|on Serie|
|00006250| 73 20 33 20 0a 77 69 74 | 68 20 74 68 65 20 53 70 |s 3 .wit|h the Sp|
|00006260| 72 65 61 64 73 68 65 65 | 74 20 70 6c 75 67 67 65 |readshee|t plugge|
|00006270| 64 20 69 6e 74 6f 20 6f | 6e 65 20 6f 66 20 74 68 |d into o|ne of th|
|00006280| 65 20 53 43 44 20 64 72 | 69 76 65 73 2c 20 79 6f |e SCD dr|ives, yo|
|00006290| 75 20 77 69 6c 6c 20 0a | 73 65 65 20 61 74 20 6c |u will .|see at l|
|000062a0| 65 61 73 74 20 74 68 72 | 65 65 20 64 69 72 65 63 |east thr|ee direc|
|000062b0| 74 6f 72 69 65 73 20 41 | 2c 20 43 20 26 20 4d 20 |tories A|, C & M |
|000062c0| 28 49 20 75 73 65 20 64 | 72 69 76 65 20 41 20 72 |(I use d|rive A r|
|000062d0| 61 74 68 65 72 20 74 68 | 61 6e 20 0a 42 20 69 6e |ather th|an .B in|
|000062e0| 20 6f 72 64 65 72 20 6e | 6f 74 20 74 6f 20 63 6f | order n|ot to co|
|000062f0| 76 65 72 20 74 68 65 20 | 62 61 63 6b 75 70 20 62 |ver the |backup b|
|00006300| 61 74 74 65 72 79 29 2e | 0a 0a 4f 70 65 6e 20 64 |attery).|..Open d|
|00006310| 69 72 65 63 74 6f 72 79 | 20 4d 20 61 6e 64 20 74 |irectory| M and t|
|00006320| 68 65 6e 20 53 50 52 2e | 20 20 53 50 52 20 69 73 |hen SPR.| SPR is|
|00006330| 20 74 68 65 20 64 69 72 | 65 63 74 6f 72 79 20 69 | the dir|ectory i|
|00006340| 6e 20 77 68 69 63 68 20 | 61 6c 6c 20 0a 79 6f 75 |n which |all .you|
|00006350| 72 20 73 70 72 65 61 64 | 20 73 68 65 65 74 73 20 |r spread| sheets |
|00006360| 61 72 65 20 73 74 6f 72 | 65 64 2c 20 74 68 65 79 |are stor|ed, they|
|00006370| 20 61 72 65 20 61 6c 6c | 20 72 65 70 72 65 73 65 | are all| represe|
|00006380| 6e 74 65 64 20 62 79 20 | 74 68 65 20 0a 61 62 61 |nted by |the .aba|
|00006390| 63 75 73 2c 20 61 73 20 | 6f 6e 20 74 68 65 20 53 |cus, as |on the S|
|000063a0| 79 73 74 65 6d 20 73 63 | 72 65 65 6e 2c 20 66 69 |ystem sc|reen, fi|
|000063b0| 6c 65 20 74 79 70 65 20 | 26 46 42 43 20 28 66 62 |le type |&FBC (fb|
|000063c0| 63 29 2e 0a 0a 4f 70 65 | 6e 20 74 68 65 20 64 69 |c)...Ope|n the di|
|000063d0| 72 65 63 74 6f 72 79 20 | 77 69 74 68 20 74 68 65 |rectory |with the|
|000063e0| 20 66 69 6c 65 20 79 6f | 75 20 77 69 73 68 20 6c | file yo|u wish l|
|000063f0| 6f 61 64 20 69 6e 74 6f | 20 50 73 69 6f 6e 20 2d |oad into| Psion -|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.